Skip to content

Registered aircraft · 22,413

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.

N428SGriffing Flying Service Inc · Port Clinton, OHBuilt 1980 · S/N 32-8106021 N4290RLadet David E · Lavonia, GABuilt 1969 · S/N 32-40666 N4291JImai Benjamin T · Silverado, CABuilt 1967 · S/N 28-22656 N4291SHobart Aviation Inc · Akron, OHBuilt 1982 · S/N 28-8316036 N42927Strickland Albert L · Capitola, CABuilt 1974 · S/N 28-7415406 N4292JReds Aircraft LLC · Edinburg, TXBuilt 1967 · S/N 28-22660 N4292KPakiri Aviation LLC · San Antonio, TXS/N 32R-8329013 N4292LSwank Aaron J · Fairview Park, OHS/N 28-8311012 N4292RSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 32-40669 N4292SD&D Design Manufacturing Inc · Oklahoma City, OKBuilt 1983 · S/N 32R-8329014 N4292YWalters Jason · Palm Springs, CABuilt 1983 · S/N 28-8390037 N4293CNussbaum Rod M · Bradenton, FLS/N 28R-8331024 N4293JCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1967 · S/N 28-22661 N4293RLaws Chris · Mckenzie, TNS/N 32-40671 N4293YArcher N4293y LLC · Tulsa, OKBuilt 1983 · S/N 28-8390040 N42942Mott Plane LLC · Morning Sun, IABuilt 1983 · S/N 32-8306018 N42945Pollnow Dean M · West Bend, WIBuilt 1983 · S/N 32-8306020 N42946Perchard Baron D · Schaumburg, ILBuilt 1983 · S/N 28R-8331025 N4294JWahner Rudolf M Jr Trustee · Aston, PAS/N 28-22663 N4294NCoastal Aviation LLC · Virginia Beach, VABuilt 1983 · S/N 32R-8313011 N4294PAex Enterprises LLC · Alexandria, LABuilt 1983 · S/N 32R-8329015 N4294TSopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1971 · S/N 28-7205134 N4295RGhost Riders Aoo LLC · Altoona, PABuilt 1983 · S/N 28-8311014 N4296NScholz Daniel Joseph · Mantorville, MNBuilt 1983 · S/N 32-8306021 N4296RJohnstone Colin · Enterprise, ALS/N 32-40674 N4296SB J Air Inc · Wilmington, DEBuilt 1983 · S/N 32-8306022 N4296TD'Haem Christopher M · East Lansing, MIBuilt 1983 · S/N 32-8324009 N4296XWilco Consulting LLC · Elkhart Lake, WIBuilt 1983 · S/N 32-8324010 N42970Digbus Aviation LLC · Sheridan, WYS/N 28R-8331030 N42979Dashanddash LLC · Athens, GABuilt 1983 · S/N 32R-8329021 N4297CEv Aviation LLC · Elizabeth, COBuilt 1983 · S/N 32R-8329019 N4297MInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316056 N4297R4297 Romeo Aviation LLC · Owasso, OKBuilt 1969 · S/N 32-40675 N4297YPalmer John · Duluth, MNBuilt 1983 · S/N 28R-8331029 N42982Dassin Andre · Altadena, CABuilt 1983 · S/N 28-8390050 N42985Hall Jason · Iron Mountain, MIBuilt 1983 · S/N 32-8306023 N42986Xp Inc · Rehoboth Beach, DEBuilt 1983 · S/N 32-8306024 N42987Gman Air LLC · Clayton, MOBuilt 1983 · S/N 32R-8313017 N4298LToon Corey A · Carthage, TXBuilt 1983 · S/N 28-8316058 N4298RAv79 Aviation LLC · Dover, OHBuilt 1969 · S/N 32-40677 N4298VLuitjens Jabob J · Cascade Locks, ORS/N 28-8316059 N42990Montemayor Anselmo · Duncanville, TXS/N 32R-8329024 N42993Bc Aviation LLC · Valdosta, GAS/N 32-8306025 N4299RRimlinger Timothy Trustee · Audubon, PABuilt 1969 · S/N 32-40678 N4299XFerguson Teresa · Houston, ARBuilt 1983 · S/N 32-8324012 N429EGCongalton Steve M · Rancho Cucamonga, CABuilt 1974 · S/N 28-7405188 N429SFLewis Jason M · Camden, ARBuilt 1979 · S/N 32-7940136 N42AGBeck William J · Phoenix, AZS/N 28-7110014 N42CJNewman Robert A · Discovery Bay, CABuilt 1979 · S/N 32-7940149 N42CXSilver Hawks Ltd · Columbus, OHBuilt 1973 · S/N 32-7340142

Back to AD 87-08-08 R3