Registered aircraft · 54,019

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.

N172HTAuto Outlet Of Irvington LLC · Irvington, NJS/N 17257091 N172JAPalmenteri Louis J · Rhome, TXBuilt 1966 · S/N 17254401 N172JBWood Jonathan R · Sedgwick, MEBuilt 1973 · S/N 17262206 N172JDBlack Hound Aviation LLC · Austin, TXBuilt 1974 · S/N 17263844 N172JGGroendyke Jerry G · Fort Pierce, FLBuilt 1969 · S/N 17257987 N172JHHaugen Jim · Maiden Rock, WIBuilt 1962 · S/N 17248803 N172JJFort Leavenworth Flying Activity · Fort Leavenworth, KSBuilt 1975 · S/N 17265488 N172JKHillman Aviation LLC · Bossier City, LABuilt 1964 · S/N 17251337 N172JLSutton Aircraft Salvage LLC · Palmer, AKS/N 17257724 N172JMCardinal Wings Aviation LLC · Buckner, KYS/N 17262202 N172JNRedd Charles · Dutton, MTS/N 36919 N172JTLiberty Zone LLC · Wilmington, DEBuilt 1964 · S/N 17251132 N172KMenard Keith · Bellevue, TXS/N 0749 N172KAVenture North Aviation LLC · Cloquet, MNS/N 172RG0854 N172KCWellner Thomas B · Bremerton, WABuilt 1965 · S/N 17252649 N172KDKad Aviation LLC · Athens, ALBuilt 1976 · S/N 17267467 N172KGSimons Laura · London, KYS/N 17270311 N172KJJa Flight Services LLC · Sugar Cove, ILS/N 17268124 N172KPBitzan Joseph D · Charlotte, NCBuilt 1968 · S/N 17257218 N172KRRose Kim M · Mount Vernon, OHBuilt 1965 · S/N 17252960 N172KWTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272254 N172KYAir Dogs LLC · Mount Washington, KYBuilt 1975 · S/N 17266093 N172LCIfly Aviation LLC · Conway, ARBuilt 1974 · S/N 17263219 N172LFSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1979 · S/N 17273380 N172LGPolk Brandon A · Valrico, FLBuilt 1974 · S/N 17264203 N172LJN W Aviators Inc · Troutdale, ORBuilt 1975 · S/N 17266242 N172LNFly Aviation Corp · Wilmington, DEBuilt 1981 · S/N 17274794 N172LRDevillers Daniel R · Kalamazoo, MIBuilt 1960 · S/N 47607 N172LWCrane Donald L · Kenai, AKBuilt 1967 · S/N 17255790 N172MBStone Wall Acres · Antigo, WIS/N 36824 N172MC172 Mikecharlie LLC · Ocala, FLBuilt 1975 · S/N 17265980 N172MDDc Aerial Photos Inc · Fredericksburg, VABuilt 1974 · S/N 17263421 N172MEBlue Ridge Airworks LLC · Charlottesville, VABuilt 1974 · S/N 17263996 N172MFRhody Skyhawk Flying Club LLC · Middletown, DES/N 17258001 N172MHHoward Michael G · Slaughters, KYBuilt 1978 · S/N 17271660 N172MKRivera Glauco A · Isabela, PRBuilt 1976 · S/N 17266714 N172MLHampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17261580 N172MMEwing & Coryell LLC · Nixa, MOS/N 172RG0286 N172MPPasswater Michael E · Upland, CABuilt 1961 · S/N 17248976 N172MRGorge Winds Aviation Inc · Fairview, ORBuilt 1976 · S/N 17267684 N172MSAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1974 · S/N 17263928 N172MXDmac Aircraft LLC · Savannah, GAS/N 17269939 N172NEast Tennessee Pilots Club · Knoxville, TNBuilt 1978 · S/N 17270403 N172NCChase James W · Port Orange, FLS/N 17260468 N172NFPreston Richard R Trustee · Albuquerque, NMS/N 17275911 N172NPDv Aviation Inc · Brainerd, MNBuilt 1978 · S/N 17270971 N172NSWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17257968 N172NXHolcomb Garry M · Point, TXBuilt 1960 · S/N 17248148 N172PARoseville Aviation LLC · Roxboro, NCS/N 17269467 N172PESale Reported · Kenmore, WASale reportedBuilt 1979 · S/N 172RG0042

Back to AD 87-20-03 R2