Skip to content

Registered aircraft · 4,242

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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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.

N732KCKing Daddy Aviation LLC · Madison, MSBuilt 1976 · S/N 21061564 N732KPB&M Aviation LLC · Montgomery, TXBuilt 1976 · S/N 21061575 N732KQPerea Rudolph A · Dayton, NVBuilt 1976 · S/N 21061576 N732NLHutton Construction Inc · Florence, MTBuilt 1976 · S/N 21061643 N732PGSims Chas W · Deer Park, TXS/N 21061661 N732PQPilcher Nick A · Perryton, TXBuilt 1976 · S/N 21061669 N732QCHoldaway Daniel C · Orem, UTBuilt 1976 · S/N 21061681 N732QXT & A Transport LLC · Garden City, KSBuilt 1977 · S/N 21061700 N732RBGauthier Alan Trustee · Flemington, NJBuilt 1977 · S/N 21061704 N732RFWolvington Howard W · Genoa, NVBuilt 1980 · S/N P21000591 N732RLAero Aviation Transportation Inc · Wilmington, DEBuilt 1977 · S/N 21061713 N732RVJongum LLC · Allentown, PAS/N 21061722 N732SEPic Aviation Inc · Bloomsburg, PABuilt 1977 · S/N 21061731 N732SMKonstantinopoulos George · Vacaville, CABuilt 1977 · S/N 21061738 N732SRLucas Gilbert C DBA · Santa Rosa, CABuilt 1977 · S/N 21061742 N732SSAlbert Aviation LLC · Kalispell, MTBuilt 1977 · S/N 21061743 N732SVN732sv LLC · Dallas, TXS/N 21061746 N732TCKam Aviation LLC · Maryville, TNBuilt 1977 · S/N 21061753 N732TJEscalante Aviation LLC · Boerne, TXBuilt 1976 · S/N 21061507 N732TPBdf Air Investments LLC · Galveston, TXBuilt 1977 · S/N 21061764 N732TYTennison Gary · Marion, TXBuilt 1977 · S/N 21061772 N732UHUpwind Air LLC · Atoka, OKBuilt 1977 · S/N 21061781 N732UJJohnson Andrew · Carrollton, TXBuilt 1977 · S/N 21061782 N732UMCurtis Blake B · Clovis, NMBuilt 1977 · S/N 21061785 N732UUAll In Flying Co · Wilmington, DEBuilt 1977 · S/N 21061792 N732VPStoneman Excav Co Inc · Manakin Sabot, VABuilt 1977 · S/N 21061811 N732WFWestairnetwork LLC · Kalispell, MTBuilt 1977 · S/N 21061827 N732WNKilpatrick Robert Levon · Auburndale, FLBuilt 1977 · S/N 21061834 N732WPSky Wings Aviation LLC · Cedar Rapids, IABuilt 1977 · S/N 21061835 N732WQLos Angeles County Sheriffs Department · Long Beach, CABuilt 1977 · S/N 21061836 N732WSMurphy Timothy J Trustee · Arcadia, CABuilt 1977 · S/N 21061838 N732XFWwabfa LLC · Dallas, TXBuilt 1977 · S/N 21061851 N732XHGwin Brandy L · El Lago, TXBuilt 1980 · S/N P21000596 N732XL5239g LLC · Auburn, ALBuilt 1977 · S/N 21061856 N732XVHanley John F · Chicago, ILBuilt 1977 · S/N 21061865 N732YBRieber Gerald Michael · Watertown, SDS/N 21061871 N732YCGiudici Carl E · Henderson, NVBuilt 1977 · S/N 21061872 N732YDPrivate Air LLC · Santa Rosa, CABuilt 1977 · S/N 21061873 N732YKDaly Arthur P · El Paso, TXFirst renewal noticeBuilt 1977 · S/N 21061879 N732ZANorthstar Center Properties · Los Angeles, CABuilt 1977 · S/N 21061894 N732ZBMuddy Wolf Holdings LLC · Wilmington, DEBuilt 1977 · S/N 21061895 N732ZCHoffman Dean Jr · Santa Ana, CABuilt 1977 · S/N 21061896 N732ZGStraight And Level LLC · Solana Beach, CABuilt 1977 · S/N 21061900 N732ZHDe La Porte Herb · Elyria, OHBuilt 1981 · S/N P21000599 N732ZMTurbo 210 Air LLC · Galveston, TXBuilt 1977 · S/N 21061905 N732ZZDakota Aerial Ministries · Fargo, NDS/N 21061917 N7334NRobles James J · Oro Valley, AZBuilt 1976 · S/N U20603616 N7334PUp And Away Aviation LLC · Poughkeepsie, NYS/N P21000004 N7336CDelta Kilo Av8 LLC · Bonita Springs, FLS/N 21063938 N733EHSherwood Aviation Consultants Inc · Redondo Beach, CABuilt 1978 · S/N U20604761

Back to AD 89-24-01 R1