AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.
N94LBWhetzel Russell R · Milford, NJN94LESky Path N94le LLC · Carmel, INN94LJFrostenson Bobi J · Fairfield, IDN94MBReese Elizabeth J · Glade Park, CON94MPMissouri State Highway Patrol · Jefferson City, MON94NARegistration Pending · Northampton, MARegistration pendingN94PKAshwill Gregory L Trustee · Overgaard, AZN94RTRoholt Philip C · Canton, OHN94SBBernatz Gerald F · Highland, ILN94SDKaeder Carpenter Deborah A · Inver Grove, MNN94SJMoe Alan D · North Bend, ORN94SKKeen Douglas C · Munith, MIN94TBMartin Robert L III · Covesville, VAFirst renewal noticeN94TDKirk Tim L · Hilltop Lakes, TXN94TFWildblue LLC · Edgerton, MON94TSPetersen Andrew John · Saint Paul, MNN94VFPenhorwood Joshua M · Shubuta, MSN94WAVidal Aviation LLC · Gaithersburg, MDN94WDRegistration Pending · Sugar Grove, ILRegistration pendingN94WGAltruda Thomas Joseph · Las Vegas, NVN94WSParker Rob · Oklahoma City, OKN94WYMiller Thomas Baker · Tigrett, TNN94XTaylor Samuel R · Kenai, AKN94YCBeauchene Mark J · Des Moines, IAN95005Christiansen Aviation LLC · Wilmington, DEN95008Ottaway Brent E · Derby, KSN9500DFlight Club LLC · Anchorage, AKN9500JMidwest Air Freight LLC · Sioux City, IAN9500LAtlantic Aero Club Inc · Newark, DEN9500MZoom Thusiasts LLC · Smyrna, GAN9500WRachel Calvin · Kimberly, ALN9501DBelof Joshua · Franklin, NCN9501JKnutson Donald W · Litchfield, MNN9501MCasterline Douglas J · Kansas City, MON9501WAwwad Mamdouh A · Walnut Creek, CAN95021Space Coast Aircraft Co · Merritt Island, FLN9502BGraceffa Salvatore · Atascadero, CAN9502HYoung Roger A II · Wasilla, AKFirst renewal noticeN9502MStorer Daniel A · Guthrie, OKN9502WHellevang Ryan K · Duvall, WAN95031Pratt John · Anchorage, AKN9503DHardison Allan · Castle Rock, CON9503MCurell Kenneth E · Centerville, OHN9503QGulf Coast Helicopters Inc · Pearland, TXN9503UAom Aircraft LLC · Wilmington, DEN9503VMcdonald Michael A · Village Mills, TXN9503WLoya Armando · Whittier, CAN9503YRoss Carl D · Arbuckle, CAN95044Mach Point Two Aviation LLC · Conroe, TXN9504DWilliams Jimmy Z · Sherman, TX
Back to AD 81-18-04 R2