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.
N8022YDanis Paul A · Woodinville, WAN80230Fly Nh Aviation LLC · Bow, NHN80238Hess Garrett J · Fullerton, CAN80239Borreson Anthony · Mariposa, CAN8023DSanchez Pascual G · Pantego, NCN8023NStafford Craig A · Tempe, AZN8023PShisier William · Tempe, AZN8023WHydroplane Ltd · Sherman Oaks, CAN80246Lincoln Skyways Inc · Lincoln, CAN80248Mtm Deland LLC · Deland, FLN8024NAll American Aviation Services Inc · Fayetteville, NCN8024PC Five Ranch Inc · Leoti, KSN8024YValiair Lc Trustee · Casper, WYN8025Buergel Sandra J · East Aurora, NYN80251Harrison Social Flites Inc · Harrison, OHN80254On Glideslope LLC · Middletown, DEFirst renewal noticeN8025EMission Aviation Fellowship · Nampa, IDN8025JTorres Rafael · San Juan, PRN8025N8025n Flyers Ltd · Monsey, NYN8025RGaboury Michael J · Two Harbors, MNN8025WMann Nicholas Lee · Grand Canyon, AZN8025XCivil Aviation Leasing Ltd · Wilmington, DEN80263Breton Yacht Co LLC · Schenectady, NYN80267Bisson James H · Piercefield, NYN8026NJenkins Carl S · Muncy, PAN8026PMontgomery Investments Inc · Washington, UTN8026QInternational Fun Place Hangar 32 LLC · Laughlin, NVN8026YCaillouet Andre E Jr · Houma, LAN80270Fisher Robert · Shoreacres, TXN80277Usaeroflight LLC · Greenville, SCN80278Baur Ronald N · Gig Harbor, WAN80279Tueller John D · Spring Creek, NVN8027FCyganski David · Palm Beach Gardens, FLN8027YGreek Housing Services Corp · Port Matilda, PAN80282Nguyen Nhu-An T · Bethesda, MDN80283Barxbar Aviation LLC · Mesa, AZN80287Campbell Frederick G · Rigby, IDN8028PTrest Robert J · Pelzer, SCN8028RBorgers Thomas R · Palmyra, NJN8029Sorenson Tyler D · Bountiful, UTN80291Davidson Doug W · Newcastle, WAN80295Legacy Skies Aviation LLC · Rogers, ARN80298N80298 LLC · Miami, FLN80299Mountain Air Aviation Inc · Bethesda, MDN8029NHeydenreich Jacob N · Hartford, ARN8029PLong Trevor J · Flower Mound, TXN802ATFlight School Of Texas LLC · Wilmington, DEN802CMN802cm LLC · Lebanon, MON802DDN802dd Corp Trustee · Wilmington, DEN802DPGross Robert M · York, ME
Back to AD 87-10-06 R1