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.
N78JDArtigas Gonzalo J · Cambridge, MAN78JHPlane Fun Inc Tr Trustee · Snellville, GAN78JMDye William M · Atlanta, GAN78JNMuseum Of Flight Foundation · Seattle, WAN78JRFocus Air LLC · Wilmington, DEN78JSJet South LLC · Medford, NJN78JT71793 LLC · San Luis Obispo, CAN78KPYoungblood Dennis L · Crystal River, FLN78KTJbt Aviation LLC · Shawano, WIN78KVShore Dog Aviation LLC · Dover, DEN78LJValiair Lc · Casper, WYN78LSNor-Cal Air LLC · Kalispell, MTN78MJTalley Patricia · Asheboro, NCN78MRShembekar Ajit R · Novi, MIN78MSDibenedetto Todd P · Riverwoods, ILN78MUKoonce John P · Jefferson City, MON78MVWhittington Rankin A Trustee · Lenoir, NCN78NJBessie Aviation LLC · Lexington Park, MDN78NPHeaton Justin · Lufkin, TXN78NSRobertson Lester M · Hamilton, OHN78PDBryant Jerry L · Punta Gorda, FLN78PJRothrock John W Jr · Danville, INN78PLDunaway Dennis G Jr · Port Orange, FLN78PPToman Gregory R · Caledonia, MIN78PWPower Joe D · Seguin, TXN78QBPandion Aviation LLC · West Chester, PAN78QPHilyer Bruce W Trustee · Seattle, WAN78RFFairchild Maxwell D · Morristown, TNN78RGBubber Inc · Lake Providence, LAN78RJUsaeroflight LLC · Greenville, SCN78RLDavis Murray L · Fair Play, CAN78RTMorris Coady C · Russell, KSFirst renewal noticeN78SEFlight Fundamentals Inc · Willcox, AZN78SKCleveland Gary J · Plymouth, INN78TACti Aircraft Leasing LLC · Memphis, TNN78TGGardner Terrence L · Grassy Creek, NCN78TKFinseth Lowell J · Fountain, MNN78TMBowlin Ronald R · Camarillo, CAN78TSCeleritas Corp · Cranford, NJFirst renewal noticeN78VLAdams Michael · Oxnard, CAN78VMPileggi Anthony · Leland, NCN78WARtd Aviation LLC · Hillsborough, NJN78WBDuffy James R · Boise, IDN78WESouth Delta Aviation Inc · West Helena, ARN78WGBarros Da Costa Cristiano Manuel · Grand Forks, NDN78WTCole Thomas Ed · White Settlement, TXN79000Kemmis Sidney C · Prophetstown, ILN79001Pau Hana Enterprises LLC Series IV · Boulder City, NVN79002Fremont Aviation Inc · Fremont, NEN79004Palmer Joe A · Meridian, ID
Back to AD 87-10-06 R1