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.
N9307MCassling Edward F · Newark Valley, NYN9307SRearick Scott P · Frederick, MDN9307WHedgers Thomas W · Lino Lakes, MNN9308JYoung Ashley G · Lexington, NCN9308MDegraaf Derrick B · Manteca, CAN9308PExecutive Enterprise Solutions LLC · Mount Pleasant, SCN9308VDapaah Seth O · Upper Marlboro, MDN9308WHubbard Manu L · Riverside, CAN9309KVera Rojas Guillermo A · Albuquerque, NMN930AMDel Mar College · Corpus Christi, TXN930ERDodson International Parts Inc · Rantoul, KSFirst renewal noticeN930GFThierry Robert J · Pottstown, PAN930KGGriggs Roger · Columbia, SCN930LTAerosim Flight Academy · Sanford, FLN930MCook Christopher K · Wintersville, OHN930MAPlaceway Scott M · Lapeer, MIN930MDTab Associates Inc DBA · Port Saint Lucie, FLN930TEPeters James L · Lindon, UTN930ZMirage 930 Corp Trustee · Wilmington, DEN931Registered aircraftN9310DRegistered aircraftN9310HLilienthal Donald W · Cyrus, MNN9310JBuckwalter Russell · Broadway, VAN9310NApproach Partners LLC · Franklinton, NCN9310WGb Aviation LLC · Alpine, CAN9311DRegistration Pending · Knoxville, TNRegistration pendingN9311JSentelle Amanda L · Frederick, MDN9311MShamshir LLC · Lake Havasu City, AZN9311NAmendt Joseph J III · Plymouth, MNN9311VRegistration Pending · Queen Creek, AZRegistration pendingN9312DMcdonald Steve W · Lino Lakes, MNN9312MSteinman Marc J · Frankfort, ILN9312PGregory John P · Riverside, CAN9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORN9313CWright Terrence Richard · Tiffin, OHN9313DSteneker Siardus L · Vashon, WAN9313HFlying Ten Flying Club · Phoenix, AZN9313JLockhart Michael B · Redlands, CAN9313KStauffer Donald R Jr · Tracy, CAN9313M9313 Mike Inc · New Smyrna Beach, FLN9313PPencosky Edward A Jr · Manorville, NYN9313WDjb Aviation LLC · Pompano Beach, FLN9314DCallahan Ashton G · Homer, AKN9314EHall Kenneth B · Merritt Island, FLN9314HAzevedo Bradley J · San Francisco, CAN9314PCapoferri Robert · Hammonton, NJN9315DZoviv Michael · Hollywood, FLN9315ESmith Mark S · Cornville, AZN9315JKruthoff Bret · Charles City, IAN9315NDiir County Flying Inc · Sturgeon Bay, WI
Back to AD 87-10-06 R1