Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N1536YCk Aviation LLC · Williamstown, NJBuilt 1962 · S/N 17249236 N1537YAloha Skies Aviation LLC · Pahoa, HIBuilt 1962 · S/N 17249237 N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651 N1538YPrice Andre D · Granger, INBuilt 1962 · S/N 17249238 N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040 N153PCRegistered aircraftBuilt 2009 · S/N 172S10956 N1541UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267169 N1544CElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8365 N1544EAtlas Aero Training LLC · Casper, WYBuilt 1978 · S/N 17271041 N1545ESlipstream Aviation LLC · Carrollton, GABuilt 1978 · S/N 17271042 N1546VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263654 N1547YBurgo Randy P · Alameda, CABuilt 1962 · S/N 17249247 N1549YLotwala Pathik · Woodbine, MDBuilt 1962 · S/N 17249249 N1550EWilts George W · Streator, ILBuilt 1978 · S/N 17271043 N1550VJar Investments LLC · Kalispell, MTBuilt 1974 · S/N 17263655 N1551VBumpe Logistics LLC · South Jordan, UTBuilt 1974 · S/N 17263656 N1552YRobinson Charles F · Beach City, TXBuilt 1962 · S/N 17249252 N1555VGinther Michael P · Lemmon, SDBuilt 1974 · S/N 17263658 N1558EFlores Frank J · Ozark, MOBuilt 1978 · S/N 17271046 N155CWPotcake Aviation LLC · Mcminnville, ORBuilt 1975 · S/N 17265697 N1560EAmerican Airman Inc · Stony Brook, NYBuilt 1978 · S/N 17271047 N1560VAvp Aviation LLC · La Jolla, CABuilt 1974 · S/N 17263663 N1561VHenkel Douglas K · Olathe, KSBuilt 1974 · S/N 17263664 N1561YFire Hound LLC · Springfield, ORBuilt 1962 · S/N 17249261 N1562YWalker Karl L · Las Vegas, NVBuilt 1962 · S/N 17249262 N1563YCraik James E · Trout Creek, MTBuilt 1962 · S/N 17249263 N1564EElizabethtown Flying Service Inc · Elizabethtown, KYBuilt 1978 · S/N 17271048 N1564YBurkes Mark E · Denison, TXBuilt 1962 · S/N 17249264 N1567VRasmussen Bryan K · Wilsonville, ORS/N 17263668 N1569YPropp William D · Azle, TXBuilt 1962 · S/N 17249269 N156DWAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 172S8342 N156MEArcher III LLC · Littleton, COBuilt 2000 · S/N 172S8435 N156XDBurgess Mark W · Greene, MES/N 17268718 N1570VMcdermott John P Trustee · Redding, CABuilt 1974 · S/N 17263671 N1570YBoggs Texe T · Sarcoxie, MOBuilt 1962 · S/N 17249270 N1571EMorgan Steven P · Roswell, GABuilt 1978 · S/N 17271049 N1571VPeabody Jeffery L · Vinemont, ALBuilt 1974 · S/N 17263672 N1572VWaldroup Anthony Wayne · Konawa, OKBuilt 1974 · S/N 17263673 N1574YBlue Hawk LLC · Rogers, MNS/N 17249274 N1575VMissouri Reliability Services LLC · Maryville, MOBuilt 1974 · S/N 17263675 N1577YConner James D · Elgin, TXBuilt 1962 · S/N 17249277 N157DF157df LLC · Madison, WIS/N 17260646 N157KCNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11037 N157MEMaine Coastal Flight Center Inc · Bangor, MEBuilt 2000 · S/N 172S8436 N1580EBermudez John M · Pembroke Pines, FLBuilt 1978 · S/N 17271051 N1580VPrecision Curbs And Concrete LLC · Shady Cove, ORS/N 17263696 N1580YG2g Aviation LLC · Wray, COBuilt 1962 · S/N 17249280 N1581YHampton Industrial · Jacksonville Beach, FLS/N 17249281 N1583YR & L Air Service LLC · Yatesville, GABuilt 1962 · S/N 17249283 N1584EDurbin William E · Parkersburg, IABuilt 1978 · S/N 17271052

Back to AD 90-06-03 R1