Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N4951GMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273498 N4951HUS Flight Academy International Inc DBA · Post, TXBuilt 1979 · S/N 15284044 N4951NCactus Av8rs LLC · Gilbert, AZBuilt 1979 · S/N 18267476 N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057 N49527B&S Aviation LLC · Sylvania, OHBuilt 1979 · S/N 15283469 N4952BC & T Aviation Holdings Inc · Mckinney, TXBuilt 1979 · S/N 15283720 N4952EHess Michael D · Wasilla, AKBuilt 1979 · S/N 18503918 N4952GHighland Rim Aviation LLC · Springfield, TNS/N 17273499 N4952TKeith Investments LLC · Verona, MSS/N R18201802 N4953AOlson Andrew P · Garfield, WABuilt 1956 · S/N 32350 N4953BTfa Holding Corp · Daytona Beach, FLS/N 15283721 N4953EInland Fisheries And Wildlife · Augusta, MEBuilt 1979 · S/N 18503919 N4953GMcfly LLC · Casper, WYBuilt 1979 · S/N 17273500 N4953TBergeron Jason Alan · San Antonio, TXS/N R18201803 N4953VMccreery Aviation Co Inc · Mcallen, TXBuilt 1980 · S/N 172RG0423 N4954DTracy Scott J · Santa Barbara, CAFirst renewal noticeBuilt 1958 · S/N 51054 N4954GKris Noone Air LLC · Wilmington, DEBuilt 1979 · S/N 17273501 N4954HVega Jaime D · Garland, TXS/N 15284045 N49551Wahl Dale H · Watertown, WIBuilt 1979 · S/N 15283474 N4955DBerman David M · Charlotte, NCBuilt 1979 · S/N 17272409 N4955THayhoe Bruce C Jr · Chippewa Falls, WIS/N R18201804 N4955YLancaster Bryant F Jr · Troutman, NCBuilt 1980 · S/N 21064058 N4956DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272410 N4956NCosta Luiz A · Fort Myers, FLBuilt 1980 · S/N 18267480 N4956VRegistered aircraftBuilt 1980 · S/N 172RG0425 N49572Karnik Brandon S · Buffalo Lake, MNBuilt 1979 · S/N 15283476 N4957APea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N A1520915 N4957DCummings Roy E · Fort Scott, KSBuilt 1958 · S/N 51057 N4957FBravo Hotel LLC · Lewes, DEBuilt 1966 · S/N U206-0657 N4957NRegistered aircraftS/N 18267481 N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059 N4958ALamonica Patrick H · San Diego, CABuilt 1979 · S/N A1520916 N4958DHarmon Jon E · Turner, MTBuilt 1958 · S/N 51058 N4958QSnider Scott E DBA · Turner, MTBuilt 1976 · S/N 18802692T N4958VFrank John M Jr · Alexandria, VABuilt 1980 · S/N 172RG0427 N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689 N4959DEdwards Stephen L Trustee · Wasilla, AKBuilt 1959 · S/N 50511 N4959VCutlass Cruisers Inc · Howard Lake, MNBuilt 1980 · S/N 172RG0428 N495EMAround The Patch LLC · Memphis, TNBuilt 1974 · S/N 18263485 N495KKatmai Air LLC · Anchorage, AKBuilt 1974 · S/N U20602549 N495RAGabbard Derek L · Paint Lick, KYS/N 15067052 N495ZZach Brian D · Loveland, COBuilt 1975 · S/N 15076595 N4960DRasmussen Scott M · Santa Cruz, CABuilt 1958 · S/N 51060 N4960JPonderosa Airtankers LLC · Safford, AZBuilt 1981 · S/N T18803791T N4960KShuck Drilling Co · Edgar, NES/N P21000383 N4960RUnited States Air Force Owner · Cannon Afb, NMBuilt 1967 · S/N 17256296 N4960UHopkins Breck G · North Little Rock, ARBuilt 1965 · S/N 21058660 N4961AGunson Robert S · Star, IDBuilt 1956 · S/N 32358 N4961ELafferty David W · Harrisburg, ORBuilt 1979 · S/N 18503922 N4961GGardner Clifton T · Vernal, UTBuilt 1979 · S/N 17273508

Back to AD 87-20-03 R2