Skip to content

Registered aircraft · 54,020

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N123KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268627 N123KTHolliday Paul B · Kiln, MSBuilt 1963 · S/N 21058218 N123LGDaniels Garry E · Humboldt, KSBuilt 1974 · S/N 17263957 N123LJRegistered aircraftBuilt 1965 · S/N 18051526 N123LSBlackford Robert G · Summit Point, WVBuilt 1973 · S/N 177RG0334 N123MBSpinner Family Lp · White City, ORS/N R1722836 N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N123PYDotson Daniel · Holly Springs, MSBuilt 1966 · S/N 17254641 N123TMJaars Inc · Waxhaw, NCS/N U20601768 N123TTMidwest Athletic Supply LLC · San Marcos, CABuilt 1979 · S/N 17272784 N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004 N123UCDavenport Jeffery W · Meadowview, VABuilt 1981 · S/N 17274649 N123UPApache Underground And Excavating LLC · Lakeside, AZBuilt 1969 · S/N 18259985 N123VCSan Bernardino Community College District · San Bernardino, CABuilt 1973 · S/N 17261890 N123VJKopp Daniel D · Buckeye, AZBuilt 1965 · S/N 18256102 N123VRLewis Edward M · Mesquite, NVS/N 210-59891 N123WEFogg Britt · Springdale, ARBuilt 1974 · S/N 177RG0628 N123WGThornhill Shaun · Greenville, OHBuilt 1963 · S/N 18254997 N123ZAFlying Colors Airparts Inc · Leesburg, FLBuilt 1970 · S/N 17259361 N12404Zook Farm Equipment Inc · Alto, MIS/N 17261976 N1240DBaeder Mark A · Mesa, AZBuilt 1950 · S/N 19794 N1240MElk Creek Investments LLC · Helena, MTBuilt 1975 · S/N 18264255 N1240VHeink Philip · Lexington, KYBuilt 1976 · S/N R1722150 N1240YChanter Connor N · Grayslake, ILBuilt 1962 · S/N 15059640 N12410Weiser Wings LLC · Houston, TXBuilt 1973 · S/N 17261978 N1241QFly Rite Aviation LLC · Fort Myers, FLBuilt 1971 · S/N 15072541 N1241UPensacola Navy Flying Club Inc · Pensacola, FLBuilt 1976 · S/N 17266936 N1242DPrice John C · Bennington, KSBuilt 1949 · S/N 18734 N1242MHenninger Bradley J · Green Cove Springs, FLS/N 18264256 N1242UWingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17266937 N12439Vann Dudley C DBA · Greenville, NCBuilt 1973 · S/N 17261982 N1243MRegistered aircraftBuilt 1975 · S/N 18264257 N1243SDecatur Flight Center LLC · Decatur, TXBuilt 1970 · S/N 17259355 N1243VAlexander Arlene Myers · Sandwich, MABuilt 1976 · S/N R1722151 N12440Bill Myer Services Inc · Friday Harbor, WABuilt 1973 · S/N 17261983 N12441Jrm Wings LLC · Farmington, UTBuilt 1974 · S/N 17261984 N12442Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 17261985 N12447Pickle Aviation LLC · Yakima, WABuilt 1973 · S/N 17261988 N12448Right Rudder LLC · Rexburg, IDBuilt 1973 · S/N 17261989 N1244DBackcountry Aviation LLC · Ankeny, IAS/N 19798 N12452Cj Aviation LLC · Sonoma, CABuilt 1973 · S/N 17261992 N12456American Patrols Inc · Midland, TXBuilt 1973 · S/N 17261994 N12459Circle S Aviation LLC · Starkville, MSBuilt 1973 · S/N 17261996 N1245BPositive Flight LLC · San Ramon, CABuilt 1975 · S/N 18264060 N1245DChism Jerry · Austin, ARBuilt 1950 · S/N 19799 N1245SMccain Michael E · Sun Valley, NVBuilt 1976 · S/N 18264814 N1245UBello Carlos E · Lawrence, MAS/N 17266940 N12460Hollenshead Andrew P · Benton, LAS/N 17261997 N12466Leaseair LLC · Wilmington, DEBuilt 1973 · S/N 17261999 N12468Sc Aviation LLC · Mooresville, NCBuilt 1973 · S/N 17262000

Back to AD 87-20-03 R2