Registered aircraft · 4,243

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.

N2708YWings Aircraft LLC · New Richmond, WIBuilt 1979 · S/N 335-0035 N2709BA&R Investments Inc · Sylvania, OHBuilt 1979 · S/N 335-0037 N2709RSchultz Daniel A · Tipp City, OHS/N 335-0039 N270MRFurtado William J III DBA · Fremont, CABuilt 1976 · S/N 21061660 N270RCEagle 1-N270rc LLC · San Juan, PRBuilt 1980 · S/N 402C0269 N2710JPeople Incorporated Of Virginia · Abingdon, VABuilt 1979 · S/N 335-0043 N2711NMountain Air Aviation LLC · Fruit Heights, UTBuilt 1980 · S/N 335-0050 N2712FDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 402C0121 N2715TDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 402C0214 N2718YRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 402C0232 N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69 N2727LAircraft Trustee Services Inc Trustee · Dover, DES/N 414A0602 N2729LVip Wellness LLC · Victoria, TXBuilt 1979 · S/N 414A0431 N2730MSua LLC · Artesia, NMBuilt 1980 · S/N 414A0437 N2732TJellor Realty Inc · Los Angeles, CABuilt 1979 · S/N 414A0449 N2734BStella Air Inc · Wyoming, PABuilt 1979 · S/N 414A0454 N2734GSplit Rock Aerospace LLC · Southport, CTBuilt 1979 · S/N 414A0456 N2735JAlpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0466 N2740TKraybill Paul D · Portola Valley, CABuilt 1979 · S/N 310R1843 N2742HWilbert John W III · Plaquemine, LABuilt 1979 · S/N 340A0929 N2743JColman Scott · Tampa, FLBuilt 1976 · S/N 21061690 N2744PTouchdown LLC · Pls Vrds Est, CABuilt 1979 · S/N 340A0941 N2744XAccelerated Slipstream LLC · Livermore, CABuilt 1981 · S/N 414A0812 N2744YDe Vuyst Richard C · Pampa, TXBuilt 1979 · S/N 340A0943 N27457Felix Margarita G · Nogales, AZBuilt 1981 · S/N 414A0813 N2745FAlexander Production Co · San Antonio, TXBuilt 1979 · S/N 340A0949 N2745GKj3 Air LLC · Mitchell, SDBuilt 1980 · S/N 414A0622 N274DCMaggie 288 LLC · Quincy, WAS/N 340A0923 N274HAPacific Rain Inc · Arroyo Grande, CABuilt 1981 · S/N 21064274 N274MRAero Systems Inc · Broomfield, COBuilt 1980 · S/N 402C0274 N275RCGianopoulous William · Lawrence, MAFirst renewal noticeBuilt 1979 · S/N 402C0117 N277CTRoss Peter W Trustee · Lufkin, TXBuilt 1998 · S/N EA-617 N277XSalopek Rett · Las Cruces, NMBuilt 1977 · S/N 414-0925 N278PBP21000318 Inc Trustee · Wilmington, DEBuilt 1979 · S/N P21000318 N27BGGuzman Steven Manuel · Port Saint Lucie, FLS/N 340A0656 N27GPFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N U20604105 N27HALmn Aircraft Leasing LLC · Sellersburg, INBuilt 1982 · S/N T30300064 N27SC5c Aviation LLC · Scottsdale, AZBuilt 1978 · S/N P21000181 N2802JCentral States Aerial LLC · Polo, ILBuilt 1979 · S/N T18803515T N2814QGill Robert L · Dixon, CABuilt 1975 · S/N U20602998 N281UDStanley David Wayne · Burleson, TXBuilt 1981 · S/N P21000690 N283DFrohbieter Alan · Superior, COBuilt 1979 · S/N TK-112 N283RDBengtson Douglas Richard · Woodinville, WABuilt 1981 · S/N 21064320 N283TBNance Joseph W · Fort Collins, COBuilt 1977 · S/N U20603956 N2856QFoster Aaron J · Missoula, MTBuilt 1975 · S/N U20603005 N285HPGaines Robert M · Nashville, TNBuilt 1949 · S/N NAV-4-1968 N285TCSickinger Alan W · New Philadelphia, OHBuilt 1947 · S/N NAV-4-473 N286CMB&K Aircraft Leasing LLC · West Plains, MOBuilt 1986 · S/N 46-8608043 N286TCJb Aviation LLC · Waxahachie, TXBuilt 1986 · S/N 21065001 N287KMO'Connor Thomas F · Plano, TXBuilt 1980 · S/N TJ-330

Back to AD 89-24-01 R1