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.

N207CHAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1969 · S/N 20700039 N207CZBig Sky Aviation Inc · Wilmington, DEBuilt 1976 · S/N 20700355 N207DAKolb Austin · Phoenixville, PAS/N 20700607 N207DDHillyard Robert Keith · Dallas, TXBuilt 1969 · S/N 20700049 N207DFDouble R Air LLC · Miami, FLBuilt 1978 · S/N 20700430 N207DGRwr Air Inc · Tok, AKBuilt 1969 · S/N 207-00070 N207DLRegistered aircraftBuilt 1981 · S/N 20700712 N207DRRadicke Dixie A · Uvalde, TXS/N 20700372 N207ECCianchette Eric · Falmouth, MEBuilt 1952 · S/N 25328 N207FDElevation Squad Inc · York, PABuilt 1982 · S/N 20700760 N207GAngry Dragon LLC · St Thomas, VIBuilt 1969 · S/N 20700091 N207GHBridgeview Aviation LLC · Southfield, MIS/N 20700709 N207GMWaters Aero Marine Inc · South Thomaston, MEBuilt 1973 · S/N 20700217 N207GRBlue Sky Telluride LLC · Telluride, COBuilt 1979 · S/N 20700563 N207HAP & C Leasing LLC · Jupiter, FLS/N 20700742 N207HPCampbell James W · Geneva, ALBuilt 1982 · S/N 17275543 N207JUnwrapped LLC · Dover, DEBuilt 1965 · S/N P206-0086 N207JPWaters Aero-Marine Inc · Owls Head, MEBuilt 1974 · S/N 20700255 N207JVSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0121 N207MRVanderpool Robert W Sr · Red Devil, AKBuilt 1996 · S/N 20700424 N207NEHylton Kyler E · Palmer, AKBuilt 1954 · S/N 31030 N207NNCasaccio Paul E · Beesleys Point, NJBuilt 1969 · S/N 20700040 N207PAMcnutt Ross T · Xenia, OHBuilt 1970 · S/N 20700162 N207RBSutton Aircraft Salvage LLC · Palmer, AKBuilt 1980 · S/N 20700606 N207SRJaars Inc · Waxhaw, NCS/N 20700623 N207TFPhotos Unlimited Inc · Rancho Cordova, CABuilt 1978 · S/N 20700492 N207VWVanderwel Mark E · Monroe, WABuilt 1975 · S/N 20700311 N207WWalters William L · Boise, IDBuilt 1963 · S/N 18254647 N207YHGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700637 N20801Loveland Christopher K · Meridian, IDBuilt 1973 · S/N 18261216 N20803Goad Jimmy L · Bradford, ARBuilt 1972 · S/N 18261217 N20804Ceddia Stephen J · Framingham, MABuilt 1974 · S/N 17263841 N20805Welzenbach Craig L · Fair Oaks Ranch, TXBuilt 1972 · S/N 18261219 N20806Young Todd Frederick · Pensacola, FLBuilt 1972 · S/N 18261220 N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147 N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370T N2080RTigert Tommy Ray · Ovilla, TXBuilt 1964 · S/N 18255280 N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843 N2081ZMcfarland Ryan E · Jacksonville, FLBuilt 1963 · S/N 15059881 N20820Maugeri Thomas V · Frankfort, NYBuilt 1972 · S/N 18261232 N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848 N20824Seven Hills Skydivers Inc · Madison, WIFirst renewal noticeBuilt 1972 · S/N 18261236 N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849 N20828Merrow R Loring · Beverly, MABuilt 1972 · S/N 18261238 N2082GKennedy Daniel M · Boise, IDBuilt 1958 · S/N 51382 N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372T N2082ZRamirez Frank Torres · Santa Rosa, CABuilt 1963 · S/N 15059882 N20831Olg Air LLC · Miami Gardens, FLS/N 18261239 N20832Wallace Fred · Ada, OKBuilt 1972 · S/N 18261240 N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850

Back to AD 87-20-03 R2