AD 84-10-01 R1
Registered aircraft · 20,481
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
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:84-10-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:84-10-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:84-10-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:84-10-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.
N5355NFlying South LLC · North Charleston, SCN5356NCacka Rudolph Jr · Wenatchee, WAN5357BSewellfarm LLC · Thaxton, MSN5358BMidwest Air Services Inc · Ray, MIN5358TCarr Jon C · Shell Knob, MON5358UMadson Chris · King City, CAN5359APalo Duro Aircraft Services Lc · Mckinney, TXN5359BLebbon Lee T · Annville, PAN535AKWilson Thomas Henry III · Anchorage, AKN535DCCamber Air LLC · Santa Ana, CAN53610Joe Wigginton Leasing LLC · Henderson, NVN5361BSkydive Ricks LLC · Petersburg, OHN5361DPannone Steven R · Palmer, AKN5362AFerguson Lynn D · Alpine, WYN5363ULefore Jeffry Thomas · Milton Freewater, ORN5364BWest James L · Roswell, NMN5366DHeinrich Rivero Hinze Max · San Antonio, TXN5366SCraig Daniel O · Baytown, TXN5367DBandrowicz Leon A · Shelby, MIN5368AValiair Limited Co Trustee · Casper, WYN5368BGachis Gary Allen · Vacaville, CAN5368UBornwasser Louis W · Prospect, KYN5369AMartens Charles H · Nokomis, FLN5369DBrown Hector M · Glenwood Springs, CON5369NDecio Justin M · Portsmouth, NHN5369YPollard William Edward · Big Spring, TXN536GRNational Aircraft Leasing Corp · Greenville, DEN536LAhmed Ejaz DBA · Carrollton, GAN536WCN8qb LLC · Thief River Falls, MNN5370DWhitten Wayne M Sr · North Berwick, MEN5370UPogany Steve C · Anchorage, AKN5371XMarks Max · Cape Elizabeth, MEN5372DHanks Don N · Eagle River, AKN5374DMoreau Clair L Jr · South Portland, MEN5375DRamstad Trygg J · Anchorage, AKN5376NCowgill John David · Studio City, CAN5378PBlue Skies Today LLC · Eagan, MNN5379ABrechtelsbauer Paul · Farmville, NCN5379BBtp Inc · Missoula, MTN537HPBarr Air Patrol LLC · Mesquite, TXN537SAMills Michael R · Saratoga Springs, NYN537TTDudley Lee Brent · Passadumkeag, MEN537WMWeaver John D · Susanville, CAN5380BGroll Michael · Logan, UTN5380NRackley Harvey R Jr · Liberal, KSN5381DSchallip Robert G Jr · Barbeau, MIN5381NBrentco Aerial Patrol Inc · Canton, OHN5382BBook Paul A · Richvale, CAN5383ASummers Timothy P · Rincon, GAN5383NCivil Air Patrol Inc · Maxwell Afb, AL
Back to AD 84-10-01 R1