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.
N431MARegent Trust Corporation Trustee · Wichita, KSN431MLFarr Francis A · Bozeman, MTN431NSSarkinen Scott W · Amboy, WAN431RAJimenez Raymond C · Gardena, CAN431RMPierzchalski Aidan K · Stevenson Ranch, CAN431SAArgotsinger Michael · Wichita, KSN431SMPongracz Brian · Redding, CAN431SPMoreno Jose J · Irvine, CAN431SSSmith Simon K · Janesville, WIN431WRettenmaier Kim J · Columbia, MON432Lazy J Aeroplanes LLC · Beverly, WVN43200Robertson Charles V II · Amarillo, TXFirst renewal noticeN43201Paul Richard · Fresno, CAN43206Hower Phillip G · Seabeck, WAN43208Thornburgh Paul J Trustee · Sun Prairie, WIN4320AKnutson Daniel T · Lodi, WIN4320FSkippys Sky Scooter LLC · Jenks, OKN4320JHaddle Eddie · Lindon, UTN4320MKoinzan Flying Service Inc · Elgin, NEN4320TBsrp III LLC · Hickory, NCN4320ZSchermerhorn Lee V D III · Oak Harbor, WAN43214Bellard Cedric · Valrico, FLN43215Gremel Tyler · Ellensburg, WAN43218On Final Aviation LLC · Brookland, ARN43219Stading William T · Hackensack, MNN4321EHarper Henry Jr · Mesquite, NVN4321FVales Louis · Monroe, NYN4321JN51343 LLC · Newnan, GAN4321QW H Flying Club Inc · Kingston, MIN4321SBeech Peak Aviation LLC · Boulder, CON4321TSale Reported · Signal Hill, CASale reportedN4321XGrady Auctions & Realty Inc · Newport, ARN4321YSchuermann Chris L · Sand Springs, OKN43221Bednarz Joseph P · Hendersonville, TNN43224Piper Aviation LLC · Tierra Verde, FLN4322FAdk Xc Flyers LLC · Scotia, NYN4322GMid Atlantic Air Museum · Reading, PAN4322JDougherty Joseph P · Hughesville, PAN4322RKing Air Charter LLC · Zanesville, OHN4322WSnell Steve · Scotts Valley, CAN4322XManitowoc Flyers Corp · Manitowoc, WIN4322ZLee Gerald R · Glennallen, AKN43232N43232 LLC · Orange, TXN43234Level Up Aviation LLC · Newton, ALN4323BBkt Holdings LLC · Mont Belvieu, TXN4323HRucker Edward A · Longview, TXN4323POverspray LLC · Norfolk, NEN4323QWausau Flying Service Inc · Wausau, WIN4323RMy Flight LLC · Cypress, TXN4323TBreitenstine Matthew · Dallas, TX
Back to AD 2007-04-19 R1