Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N9197BEsteban John G · Dublin, NHBuilt 1993 · S/N 2890192 N9197JDifabio Jack F · Newtown, PABuilt 1966 · S/N 28-3265 N919AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881948 N919BSZimin Randolph L · South Naknek, AKBuilt 1976 · S/N 32R-7680180 N919RFRegion Flyers LLC · Valparaiso, INBuilt 1981 · S/N 28-8216062 N919SPGorman Kevin V · Ebensburg, PABuilt 1999 · S/N 3257113 N91AUScreaming Duck Air LLC · Houston, TXS/N 32R-8129017 N91CGRick Jelinek Trucking Inc · Palmyra, WIBuilt 1964 · S/N 28-20214 N91DWHarlow James Patrick · Liberty Hill, TXBuilt 1967 · S/N 28-10857 N91EENorthern Tier Private Investg & Security Cnslg Inc · Towanda, PABuilt 1982 · S/N 28-8390005 N91ETAnchor Aviation LLC · Myrtle Beach, SCBuilt 1979 · S/N 32R-7985083 N91FBAircraft Partner Holdings Inc Trustee · BerlinBuilt 2003 · S/N 3257314 N91JVJv Aviation Group Inc · La Puente, CABuilt 1976 · S/N 28-7615117 N91PGTri Angle 7 · Bonham, TXS/N 28-26448 N91QAEskridge Daniel A · Heathsville, VABuilt 1969 · S/N 28-26233 N91WBethany Holdings LLC · Jamestown, NCBuilt 1969 · S/N 28-25441 N91XJCharlie Foxtrot LLC · Grand Island, NEBuilt 1978 · S/N 28-7911070 N9201JPiedmont Flight Co LLC · Nicholson, GAS/N 28-3269 N9201KGadamic LLC · Fresno, CABuilt 1976 · S/N 28R-7635224 N9201WRoush Trenton · New Haven, WVBuilt 1967 · S/N 28-10862 N9201ZOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841001 N9202JMathews Richard C · Bradenton, FLBuilt 1966 · S/N 28-3270 N9202QRongen Thomas · Fertile, MNBuilt 1993 · S/N 3213052 N9202WPatriot Flight Group LLC · Bossier City, LABuilt 1967 · S/N 28-10863 N9203JRegistration Pending · Bulverde, TXRegistration pendingBuilt 1966 · S/N 28-3271 N9203KJoseph L Catania Dvm Pc · Alturas, CABuilt 1976 · S/N 28R-7635225 N9203RSouthern Fabrication & Welding LLC · El Dorado, ARBuilt 1993 · S/N 3213044 N9203WSteward Perry F · Goetzville, MIBuilt 1967 · S/N 28-10865 N9204JCherokee N9204j Inc · Spanish Fork, UTBuilt 1966 · S/N 28-3272 N9204WMcginley Aviation Inc · Ocala, FLBuilt 1967 · S/N 28-10866 N9205JAviation Partners LLC · Greer, SCBuilt 1966 · S/N 28-3274 N9205KLancelite LLC · Corvallis, ORBuilt 1976 · S/N 32R-7680195 N9205XOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841005 N9206JBolles Aviation LLC · Johns Creek, GABuilt 1966 · S/N 28-3275 N9206NSkylink Xpress Inc · San Bernardino, CABuilt 1990 · S/N 2841301 N9206WHalley Dan R · Avery, TXBuilt 1967 · S/N 28-10868 N9207WAinakea Aviation LLC · Washoe Valley, NVBuilt 1967 · S/N 28-10869 N9209WCornell Guy Q III · Newburgh, INBuilt 1967 · S/N 28-10873 N920ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841216 N920DMCain Financial Inc · Fresno, CABuilt 1982 · S/N 28R-8231047 N920KBarker Andrew Robert · Portland, ORBuilt 1974 · S/N 28-7415038 N920PHYetiskin Kenan · Huntsville, ALBuilt 1976 · S/N 28-7615390 N9210BOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841010 N9210NShapiro Sarah Keck · Indianapolis, INBuilt 1993 · S/N 3213046 N9210WSmith Brian · Mechanicsburg, OHBuilt 1967 · S/N 28-10874 N9210XMills Anthony D · Midland, MIBuilt 1989 · S/N 3213031 N9211JBrown Herbert R · Halls, TNBuilt 1966 · S/N 28-3280 N9211WRockwell Tracey W · Atlanta, INBuilt 1967 · S/N 28-10884 N9212JJones Greg E · Thomasville, GABuilt 1966 · S/N 28-3281 N9212WProws Anthony · Othello, WABuilt 1967 · S/N 28-10885

Back to AD 87-08-08 R3