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.
N75TBMorse George A · Prescott, AZN75TCMorales Luis · Florence, ORN75TDMcmonagle Donald R · Westcliffe, CON75TJSantos Jorge · Shafter, CAN75USJbh Air LLC · Kent, WAN75UTSkyward Solutions Inc · Lewes, DEN75VEFord Randy L · Tucson, AZFirst renewal noticeN75VXSandberg Tobias · Anchorage, AKN75VYRevell Ricki A Trustee · Monument, CON75WRIngram William R Trustee · San Diego, CAN75WYDecou Gordon C · Myakka City, FLN75XCPenridge Aviation LLC · Portland, ORN7600DMangos Charles A · Rochester, NYN7600FGiles Forrest D · Springtown, TXN7600VRegistration Pending · Phillipsburg, KSRegistration pendingN7600WWeigley Kasey Jo · Graham, WAN7600YSchell Joseph H · Granbury, TXN76015Aldea Aviation Partners LLC · Encino, CAN76016Cape Fear Aviation Maintenance LLC · Fayetteville, NCFirst renewal noticeN76019Grimley Robert J · Palermo, NJN7601GWright Carl E · Conesville, OHN7601PVictory Holdings LLC · Anacortes, WAN7601URoads End Aero LLC · Erwinna, PAN7601WMartinez Frank M · Folsom, CAN7601YMines Keith A · White Cloud, MIN7602FPreston Aviation LLC · Mount Dora, FLN7602GAirborne LLC · Wilmington, DEN7602JGarrison Rodney Lynn · Atlanta, TXN7602PBischoff Brent J · Bandon, ORN76032Brown Jeffrey A · Wellington, ALN7603CSorbi Aviation Inc · El Cajon, CAN7603FJacobs Robert A · Grass Valley, CAN7603GFelstead R Keith Trustee · Medina, NYN7603HRegistered aircraftN-number assigned, not yet registeredN7603JMcclain Thomas J · Toledo, OHN7603WBe Properties II LLC · North Platte, NEN7603XHanson Scott E · Auburn, CAN76044Williams Cecil R · Clarksville, TNN76047Registration Pending · Muskogee, OKRegistration pendingN76048Larson Lee · Yuma, AZN7604FKcsi Aerial Patrol Inc · Bakersfield, CAN7604HMorehouse Brett A · Fairbanks, AKN7604LCnc Aviation LLC · Rollinsford, NHN7604YHennum Gretchen I · Eagle, CON76053Ape LLC · Birmingham, ALN76056Bormuth Alan R · Morganton, NCN7605FPromise Road Aviation Inc · Pendleton, INN7605LEagle Racer LLC · Boca Raton, FLN7605WBrownlow Gail L · Mountain City, TXN7605YPlane Care LLC · Tucson, AZ
Back to AD 81-18-04 R2