Registered aircraft · 54,015

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.

N8367BPrudek Daniel M · Rathdrum, IDFirst renewal noticeS/N 36167 N8367EGergis Pierre · Brooklyn, NYBuilt 1974 · S/N 18263191 N8367GRangesh Abinand · Newton, MABuilt 1965 · S/N 15062467 N8367LRay Allens Electronics Inc · Butler, GABuilt 1968 · S/N 17256567 N8367MConner Jacob P · Kaplan, LABuilt 1969 · S/N A1500067 N8367QDashiell Paul · Fairfield, WABuilt 1978 · S/N 18503669 N8367UTb Maintenance And Cleaning LLC · Deltona, FLBuilt 1964 · S/N 17252267 N8367XLawrence Robert J · West Point, VABuilt 1961 · S/N 17248867 N8367ZMccole Kevin · Brookline, NHBuilt 1963 · S/N 205-0367 N8368AOwens John P · Deland, FLBuilt 1952 · S/N 25220 N8368GClark Jeffrey S · Knoxville, TNBuilt 1965 · S/N 15062468 N8368JVickers Lindsay · Fuquay Varina, NCBuilt 1967 · S/N 15066268 N8368LMeltzair LLC · Fryeburg, MEBuilt 1968 · S/N 17256568 N8368QBrown Christopher · Grass Valley, CABuilt 1976 · S/N U20603229 N8368SKangas Gary J · Fairbanks, AKBuilt 1965 · S/N 18256468 N8368TYager James A · Scott City, KSBuilt 1962 · S/N 17557068 N8368XGay Morgan C · Tunkhannock, PABuilt 1961 · S/N 17248868 N8369BO'Keefe Joseph G · Madera, CABuilt 1957 · S/N 36169 N8369JDtm Enterprises Inc · Bronson, MIBuilt 1967 · S/N 15066269 N8369LInternational Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17256569 N8369UCamden Aviation LLC · Lewes, DEBuilt 1964 · S/N 17252269 N836DBR&L Sales LLC · North Vernon, INBuilt 1969 · S/N 17701366 N8370BKline Nicholas J · Alliance, OHBuilt 1957 · S/N 36170 N8370GCarter Edward D · Ethel, MOBuilt 1965 · S/N 15062470 N8370JBrown David A · Lumberton, TXBuilt 1967 · S/N 15066270 N8370MLandry Paul G · Fallon, NVS/N A1500070 N8370QState Of Alaska Dept Of Fish And Game · Palmer, AKBuilt 1976 · S/N U20603231 N8370SBerti Robert Cord · Wilton, CABuilt 1965 · S/N 18256470 N8370TGreen Benjamin · Oro Valley, AZS/N 17557070 N8370USimonsen Joshua A · White Salmon, WABuilt 1964 · S/N 17252270 N8371MNosewheels Navy LLC · Rochester Hills, MIBuilt 1969 · S/N A1500071 N8371SLamm Matthew S · Morristown, NJS/N 18256471 N8372AHegge Sharon D · Marysville, WABuilt 1962 · S/N 17249480 N8372JPaquette Michael J · Greene, NYBuilt 1967 · S/N 15066272 N8372LRed Sky Aviation LLC · Livermore, CABuilt 1968 · S/N 17256572 N8372MCollins Delbert Ray · Talihina, OKBuilt 1976 · S/N 18264597 N8372XN8372x LLC · Chelan, WABuilt 1961 · S/N 17248872 N8373AMcginn Robert W · Marion, NCBuilt 1952 · S/N 25225 N8373BSkyview Aviation LLC · Tracy, CABuilt 1957 · S/N 36173 N8373GColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1965 · S/N 15062473 N8373LFaulkner Jeannine P · Bethel, AKFirst renewal noticeBuilt 1968 · S/N 17256573 N8373MBond Hiram E · Pls Vrds Est, CABuilt 1969 · S/N A1500073 N8373QBassham Clark · Anchorage, AKBuilt 1978 · S/N 18503670 N8373SBart Bruno Paul · Monterey, CABuilt 1965 · S/N 18256473 N8373UKramer Mark S · Branchburg, NJBuilt 1964 · S/N 17252273 N8373XPenrose Cory · Reno, NVBuilt 1941 · S/N 17248873 N8374AChilds Donald R · Wasilla, AKBuilt 1952 · S/N 25226 N8374BGardner Gilbert W · Hartford, KSBuilt 1957 · S/N 36174 N8374LGeneral Aviation LLC · Henderson, NVBuilt 1968 · S/N 17256574 N8374Q8374q LLC · Gig Harbor, WABuilt 1976 · S/N U20603235

Back to AD 87-20-03 R2