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.
N474WBPhillips Kenneth R · Brackettville, TXN474ZGarcia Robert Jr · Blanco, TXN47508Beverly Flight Center LLC · Middleton, MAN47509Bartow Municipal Airport Development Authority · Bartow, FLN4750A22av Group LLC · Austin, TXN4750BConley Michael A · Mount Blanchard, OHN4750DGraves Frank C · Nocona, TXN4750FSouth Dakota Skydivers Inc · Sioux Falls, SDN4750NSaez Brian · Gilboa, NYN4750PKenefick Christopher Keith · Rosamond, CAN4750QDelaware C Plane Inc · Wilmington, DEN4750UHancock Stephen E · Yulee, FLN4751AZielinski Joseph Jr · Johannesburg, MIN4751BRegistered aircraftN4751DMoore Johnathan D · Guymon, OKN4751LBoyd Aero Services LLC · Claremore, OKN4751QHofer Bruce L · Freeman, SDN4751TAerial Perspective LLC · Mount Holly, NJN4751UPlano Daniel W · Willow, AKN47525Swanson Michael T · Melbourne, FLN4752CShannon Alton P · Intl Falls, MNN4752KAraiza Fernando A · Tucson, AZN4752LR & T Aviation Inc · White Lake, NCN4752QBrown Timothy L · Liberty Lake, WAN4752SRion Aviation Corporation · Wilmington, DEN47530Irvin Air LLC · Peru, ILN47538Mann Robert L · Lynnwood, WAN4753FRobertson Robin L · Murfreesboro, TNN4753JTiki Aerospace LLC · Saint Petersburg, FLN4753MPalotas Anne Marie · Napa, CAN4753NSimmons Todd B · Cowley, WYN4753UTurchan Robert H · Scottsdale, AZN47543Hays Cory W · Beaumont, TXN47544Maxair Inc · Coxs Creek, KYN4754AIndigo Air LLC · Gulf Breeze, FLN4754EJrm Property LLC · Taylors, SCN4754JDevendorf Donald A Jr · Prescott, AZN4754NBrentco Aerial Patrol Inc · Canton, OHN4754SNichols William R Jr · Austin, TXN47553Turbine Mentor LLC · Granbury, TXN47557M & M Aircraft LLC · Cresson, TXN47559Valiair Lc Trustee · Casper, WYN4755KPhilmar LLC · Oshkosh, WIN4755LBarnes John R · Waka, TXN4755QCook Alfred M · Juneau, AKN4755WAdobe Enterprises Of Osceola LLC · Okeechobee, FLN47560Vy Aviation LLC · Beverly, MAN47562Screen Printing USA Inc · Plymouth, PAN47564Orourke James K · Omaha, NEN4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2007-04-19 R1