Skip to content

Registered aircraft · 1,752

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3049RRls Rental Co DBA · Joplin, MOBuilt 1969 · S/N 28R-35603 N3056SMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1979 · S/N 28R-7918058 N3057RZavadil Clinton J · Sidney, IABuilt 1970 · S/N 28R-35618 N3057ZLessaris Thomas P · Huntersville, NCBuilt 1979 · S/N 28R-7918122 N3058TN3058t LLC · Cheyenne, WYBuilt 1979 · S/N 28R-7918062 N3059RTimes Arrow LLC · Highland, MDBuilt 1969 · S/N 28R-35620 N3059SRatte Clifford H · Gulf Breeze, FLBuilt 1979 · S/N 28R-7918061 N3059ZHo Chris · Weymouth, MABuilt 1979 · S/N 28R-7918123 N3060RArrow N3060r LLC · Sheridan, WYBuilt 1969 · S/N 28R-35621 N3061RCohns Willie · Elizabethtown, KYBuilt 1969 · S/N 28R-35622 N3063RGrant Scott A · Santa Barbara, CABuilt 1969 · S/N 28R-35624 N3065KBowles William Jr · New Richmond, OHBuilt 1978 · S/N 28R-7918003 N3065RFlavin Patrick J · Woodbridge, VABuilt 1969 · S/N 28R-35626 N3065ZDreiling Alexander R · Queen Creek, AZBuilt 1979 · S/N 28R-7918124 N3066KQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 28R-7918005 N3066RParker Michael A · Milwaukee, WIBuilt 1969 · S/N 28R-35628 N3066ZBate Edward F III · Rhome, TXBuilt 1979 · S/N 28R-7918125 N3067KLynch Alan J · Auburn, WABuilt 1978 · S/N 28R-7918006 N3067RSmith Julia L · Big Bear City, CABuilt 1969 · S/N 28R-35627 N3068RIsland Aero LLC · Kailua, HIFirst renewal noticeBuilt 1969 · S/N 28R-35629 N3069RBean Sheila L · San Antonio, TXBuilt 1969 · S/N 28R-35630 N3069YSeufer Trevor Scott · Wrightstown, NJBuilt 1979 · S/N 28R-7918104 N3072RRegistered aircraftBuilt 1969 · S/N 28R-35634 N3073RIngraham John W Jr · Redlands, CABuilt 1969 · S/N 28R-35633 N3074RSchwietz Thomas E · Strasburg, VAS/N 28R-35635 N3078RKitaguchi Terry S · Stockton, CABuilt 1969 · S/N 28R-35638 N3079RGrace Ryan Aviation LLC · Tomball, TXBuilt 1969 · S/N 28R-35639 N3081QInternational Air Services Inc Trustee · Carson City, NVS/N 28R-7737046 N3087RCrest Aviation LLC · Palmer, AKS/N 28R-35646 N3089RFly Bms LLC · Elkton, SDBuilt 1969 · S/N 28R-35649 N3090RCasper Clarence Jr · Groton, CTBuilt 1969 · S/N 28R-35648 N3091TSutton Aircraft Salvalge LLC · Palmer, AKBuilt 1972 · S/N 28R-7235312 N3092TTango LLC · Quaker Hill, CTBuilt 1972 · S/N 28R-7235313 N3099RMesserschmidt Brent L · Gainesville, GABuilt 1969 · S/N 28R-35668 N30DWHeffernan Michael James · Wellesley, MABuilt 1971 · S/N 28R-7135229 N30JSFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1977 · S/N 28R-7837100 N30LERollins Robert · Gadsden, ALBuilt 1971 · S/N 28R-7235018 N3131TSilver Express Co Db · Miami, FLBuilt 2004 · S/N 2844107 N31386S&L Aircraft LLC · Port Trevorton, PABuilt 1978 · S/N 28R-7837233 N31401Fox Flying Club Inc · Wheaton, ILBuilt 1978 · S/N 28R-7837234 N314LTJacobelli Raphael P · Norwalk, CTBuilt 1979 · S/N 28R-7918115 N314PWJ&S Corley LLC · Peoria, AZBuilt 2000 · S/N 2844031 N3161TKoester Carsten · San Jose, CAS/N 28R-7235144 N31649Runway Hero LLC · Wayland, MABuilt 1978 · S/N 28R-7837241 N31694Rey Al · Burlington, NCBuilt 1978 · S/N 28R-7837244 N316EFLibra Air Inc · Las Vegas, NVBuilt 1974 · S/N 28R-7435172 N316XKinney Shawn M · Camp Verde, AZBuilt 1969 · S/N 28R-35670 N31734Oscar Air LLC · Bethlehem, PABuilt 1978 · S/N 28R-7837246 N317NCField Daniel James · Bloomfield, CTS/N 28R-7635439 N3189QBoll Weevil Flyers LLC · Reedville, VABuilt 1977 · S/N 28R-7737049

Back to AD 81-11-02 R1