AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N7229ASale Reported · Belleville, ILSale reported, pending cancellationN7229TSmith Carl L · Vinita, OKN722HMRegistered aircraftN722LAllen Steven C · Crittenden, KYN72300Vieman Brian J · Owensville, MON72305Pratt Carter J · Dover Foxcroft, MEN72307Dreamco Design LLC · Elgin, ILN7230MSpring-Air LLC · De Graff, OHN72310Jackson Air LLC · Savannah, GAN72317Aviation Services Of Tn Inc · Sparta, TNN72318Olson Thomas L · Woodville, WIN72320Winkel Ray E · Glen Elder, KSN72325Registration Pending · Eagle River, AKRegistration pendingN72328Newcomer Ryan D · Monroe, GAN7232ABakunova Eugenia S · Cordova, AKN72331Reynolds Larry J · Rhome, TXN72332Registered aircraftN72333Niegel Gregory S Jr · Pleasant Grove, CAN72338Mroz Kaitlin J · Haslet, TXN72339Romstadt Eric P · Oregon, OHN7233MGunderson David A · Box Elder, SDN7233SHeidelberg Haley · Huntington, TXN72341Michaud Daniel L · Brewer, MEN72344Kong Trudith A · Auburn, WAN7234AMoore Thomas K · Pleasant View, UTN72350Beihold Paul D · Carmel, INN72354Roth Douglas D · Axtell, NEN7235XSpencer Tanya H · Coolidge, AZN72360Dellacort Laura J Trustee · Palo Cedro, CAN72362Elmira Aeronautical Associates Inc · Elmira, NYN72363Pathfinder Aero Services LLC · Sheridan, WYN72368Meech Charles G · Tampa, FLN7236SJanvrin Jerry M · Buffalo, SDN72371Clark Curtis E · Scottsdale, AZN72373Beishline Daniel · Bath, MEN72379Anderson Kacy L · San Juan Bautista, CAN7237SMetcalf Rodney K · Jonesborough, TNN72386Sommers Timothy Wade · Elizabeth City, NCN7238HStage One Associates LLC · Oxford, CTN7238MHubler Bruce F · Caldwell, IDN7238SExecutive Flight Institute LLC · Murrieta, CAN7238XInternational Air Services Inc Trustee · Carson City, NVN72393Snow Joseph A · Monroe, WIN72394Rowlett Glen R · Brookshire, TXFirst renewal noticeN72398Brewer Joshua R · Sonora, CAFirst renewal noticeN7239AEasley Daniel W · Wasilla, AKN7239MPierce Steven P · Towanda, KSN7239NSea Island Skies LLC · Ponte Vedra Beach, FLN723LAGregg James H · Parkton, NCN723LCLudwig Robert P · Pflugerville, TX
Back to AD 94-05-05 R1