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.

N2066JKlein Flying Service Inc · Lawrenceville, ILBuilt 1978 · S/N T18803356T N2069KFiloteo James · Woodinville, WABuilt 1978 · S/N TK-74 N2069YBeach Helicopter Services LLC · Chesapeake, VABuilt 1979 · S/N TK-76 N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434 N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090 N206DMBushwood Air LLC · Coeur D Alene, IDBuilt 1976 · S/N U20603512 N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291 N206GSmith Air LLC · Cascade, IDBuilt 1979 · S/N U20605268 N206GAPrijatel Thomas J · Cordova, AKBuilt 1979 · S/N U20605288 N206GVSawtooth Flying Service · Mccall, IDBuilt 1978 · S/N U20604833 N206HHSawtooth Flying Service Inc · Mccall, IDBuilt 1980 · S/N U20605675 N206JWMarley William Jay Jr · Homer, AKBuilt 1981 · S/N U20606283 N206KDStubblefield Fancho F Jr Trustee · Amity, ORBuilt 1979 · S/N U20604981 N206RCPaloma Aviation LLC · Fruitland, IDBuilt 1974 · S/N U20602431 N206SNDye Seed Ranch Inc · Spokane Valley, WABuilt 1979 · S/N U20605101 N206TZTeton Leasing LLC · Polatello, IDBuilt 1979 · S/N U20605165 N206WDCritical 32 Degrees LLC · Milton Freewater, ORBuilt 1984 · S/N U20606832 N206WPMorrison Richard Lee Trustee · Anchorage, AKBuilt 1980 · S/N U20605897 N206XKennedy Benjamin · Boulder, COBuilt 1968 · S/N P206-0479 N206XPAirborne Flyer LLC · Ashland, NHBuilt 1983 · S/N U20606701 N2070SThompson Robert V Trustee · Crawford, COBuilt 1975 · S/N 21061037 N2073LBravo Wings II LLC · Grants, NMBuilt 1976 · S/N TJ-73 N2075JL & L Flying Inc · Glen Allan, MSBuilt 1978 · S/N T18803365T N2076SWarden Air LLC · Warden, WABuilt 1975 · S/N 21061043 N207DFDouble R Air LLC · Miami, FLBuilt 1978 · S/N 20700430 N207DGRwr Air Inc · Tok, AKBuilt 1969 · S/N 207-00070 N207GAngry Dragon LLC · St Thomas, VIBuilt 1969 · S/N 20700091 N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370T N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372T N2083SDave Schmauderer · Woodland, CAS/N 21061049 N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050 N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051 N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058 N209DCDelaware Corp · Topping, VABuilt 1979 · S/N 414A0229 N209KSSchneider Kerry · Alpine, WYS/N P21000560 N20DPErvin Eric · La Follette, TNBuilt 1988 · S/N 4608140 N20JNGana Trucking & Excavating Inc · Martell, NES/N 340A0050 N20MCOpie Aviation Services LLC · Nashville, NCBuilt 1979 · S/N 25-0067 N210AAMeckley Sean H · Seattle, WABuilt 1982 · S/N 21064690 N210ABRudy Schmitt · Brookshire, TXS/N 21059209 N210ARVjc Air LLC · Katy, TXBuilt 1975 · S/N 21061077 N210AXKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 21063033 N210AZAerialtraders LLC · Estero, FLBuilt 1972 · S/N 21059678 N210BGTurner Kenneth W · Arlington, WABuilt 1978 · S/N P21000025 N210BHGlenn Wade Corp · Tucson, AZBuilt 1975 · S/N 21060954 N210BPBbsc LLC · Wilmington, DEBuilt 1981 · S/N 21064300 N210CJettech Holdings LLC · Broomfield, COBuilt 1979 · S/N P21000218 N210CCMuller Rodolfo · Kerrville, TXBuilt 1978 · S/N 21063008 N210CEMaas Aviation LLC · Pewaukee, WIBuilt 1980 · S/N P21000563 N210CFQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 21063124

Back to AD 89-24-01 R1