AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N41416Lewis Elijah J · Luthersville, GAN41419Ater Mark · Greenville, OHN4141ALady Bird Of Rhinebeck LLC · Rhinebeck, NYN4141KKimminau Jeremy · Sacramento, CAN4141TPremier Properties And Investments LLC · Tarkio, MON4141UMoss James L · Lansing, IAN4141XSpuddy Properties LLC · Leclaire, IAN4141ZBalmer Jeffrey A · Crosslake, MNN41421Blue Angel Properties LLC · Poland, OHN41429Straight Arrow LLC · Kuna, IDN4142YRegistered aircraftN41431Nally & Hamilton Enterprises Inc · Bardstown, KYN41434Groner Frank · Montrose, ALN41439Lesher James · Farmington, NMN4143ASkywest Leasing Inc · St George, UTN4143PSparrowhawk Aviation · Manvel, TXN4143SFrederickson Mark T · Cameron Park, CAN4143USwerczek Gerald Edward Jr · Tallahassee, FLN4143XBoeing Co · Renton, WAN4143YHasenfus Heidi J · Green Cove Springs, FLN4143ZRavenscroft Brant A · Box Elder, SDN41449Maccani Mark J · Bessemer, MIN4144ETradewind LLC · Wasilla, AKN4144JMclean Yvonne A · Warfordsburg, PAN4144KBoard Of Trustees · Savoy, ILN4144PChandler Air Service Inc · Chandler, AZN4144Q470 Corp · White Lake, MIN4144SJlh Ent LLC · Wilmington, DEN4144XSkywest Leasing Inc · St George, UTN4145Dittlinger Bret W · Anchorage, AKN41453Swfl Aviation LLC · Cape Coral, FLN41457Aviation Medical Experts LLC · Wilmington, DEN41459Erick Enterprises LLC · Spreckels, CAN4145AUniverstiy Of Illinois · Savoy, ILN4145GUniversity Of Illinois · Savoy, ILN4145JDyka Samuel M · Flushing, MIN4145PBlackhawk Holding Corp · Wilmington, DEN4145VGrassroots Aviation LLC · Norfolk, NEN4145XUniversity Of Illinois · Savoy, ILN4145ZJma Aviation LLC · Pompano Beach, FLN41468Boyer Daniel W · Carroll, OHN4146APinpoint Investment Capital Inc · Healdsburg, CAN4146DBird Acquisition LLC · Phoenix, AZN4146EHarrison Jeffrey L · Fairbanks, AKN4146JJackson Billy B · Los Angeles, CAN4146RUniversity Of Illinois · Savoy, ILN4146TUniversity Of Illinois · Savoy, ILN4146XOtt Dean R · Carrollton, OHN41472Jeborah Aero LLC · Jefferson City, MON41474Indian Hills Community College · Ottumwa, IA
Back to AD 2007-04-19 R1