AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N9379JDurango Air Services LLC · Wilmington, DEN9379NWinick Evan · Allentown, PAN9379PAerodata Inc · Edgewater, MDN9379WWenz Lawrence Joseph · Monroe, NYN937ASGc Aviation Services-1 LLC · Miamisburg, OHN937DBSnyder Colin · Caledonia, MIN937DCCaledonian Aviation LLC · Raleigh, NCN937LTAerosim Flight Academy · Sanford, FLN937MAMacair Aviation LLC · Xenia, OHN937SCAb Prop Plane I LLC · Metairie, LAN937TEPicton Aaron · Redding, CAN9380JMay Theodore R · Mcloud, OKN9380KResource And Management Group Ltd · Cheyenne, WYFirst renewal noticeN9380MSmith Ralph · Bel Air, MDN9380PEchelmeier Stanton M · Fort Payne, ALN9380WDg Aviation LLC · Mansfield, TXN9381DRubbert Randy C · Reynolds, NDN9381J2208 Juliet Inc · Redwood Falls, MNN9381PSouthern Aircraft Consultancy Inc Trustee · Casper, WYN9382DN9382d LLC · Wake Forest, NCN9382MBonifay Jason · Corona Del Mar, CAN9382NGarapati Prasad S · Mount Airy, MDN9382PRegistered aircraftN9382VWesterhold Wayne E · Cary, NCN9382WTraum Air LLC · Colorado Springs, CON9383JBarrowman John L · Tucson, AZN9383MTitle Benjamin H · Arlington, VAN9383NHall John G · Morrilton, ARN9383RSmith Casey B · Springer, OKN9383WJoecks David W · Del Norte, CON9384DDel Aero Service Inc · Delta, UTN9384JCrayviation LLC · Leesburg, VAN9384MNorfolk Aviation LLC · Norfolk, VAN9384PDarling Rob K Dds · Venice, FLN9385CRobinson Steven Christopher · Enid, OKN9385FReynolds Darryl G · Wills Point, TXN9385JDauzat Robbie A · Pineville, LAN9385LFixed Wing Holding Co Inc · Pembroke Pines, FLN9386JWilkes Flying Club Inc · Wilkesboro, NCN9386MWhite Jason · Lewes, DEN9386NMays David J · Lincolnton, NCN9386PWilson Jay · Omro, WIN9386REnsing Maris J · Orange, CAN9386VSwaney Matthew P · Thomasville, NCN9387DPrecise Flight LLC · Waukesha, WIN9387HAirline Transport Professionals Corp Of USA · Wilmington, DEN9387JBetzold Michael K · Anchorage, AKN9387MKastner Doug · Prineville, ORN9387VPabst Erik R · Claremont, CAN9388MN9388m LLC · Sheridan, WY
Back to AD 87-10-06 R1