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.
N736RGRegistered aircraftN736RMBagwell Danny A · Arley, ALN736RQKisic Michael L · Rector, PAN736SRegistered aircraftRegistration pendingN736TGMagleby Herbert K · Surprise, AZN736TRLangrell Sterling S · Woodburn, ORN736TSRose Clarence E III · Grove, OKN736UDSeven Ranges Mfg Corp · Carrollton, OHN736VFEdgar Warren · Granite Bay, CAN736VKGeneral Aviation LLC · Henderson, NVN736VTRucker William C Trustee · Sanger, TXN736WHB&B Island Aviation LLC · Sylvania, OHN736WPN736wp LLC · Waterford, NYN736WXStone Aviation LLC · Cusick, WAN736XPsa LLC · Fort Myers, FLN736XGStonecipher Guy Austin III · Beaumont, TXN736YLFive Star Electric Inc · Lakin, KSN736YQZupanick Joseph A · Montevallo, ALN736YWInvestments Property Holdings Aviation LLC · Jonesboro, GAN736YYYankee Yankee LLC · Bend, ORN736YZHamilton Rial Pc · Austin, TXN736ZDEllis Jack E Trustee · Tahoe City, CAN736ZGWhiskey Romeo 1 LLC · Jacksonville, FLN736ZJO'Connell Patrick J · Henderson, NVN736ZNTakemori Gil M · San Jose, CAN736ZPPaul Roussell LLC · Delhi, IAN736ZTAircraft Structural Repair Inc · Hamilton, MTN736ZVBerry Andrew J · Saint Paul, MNN736ZXRedstone Arsenal Flying Activity · Redstone Arsenal, ALN7370Kittinger Russell P · Birchwood, WIN73702Shiles Darrel J · Baltimore, MDN73707Leading Edge Flight Academy LLC · Bend, ORN7370JBoone Bradford D · Lincoln, MEN7370PLeesman Raleigh R · Blunt, SDN7370WDonahue Emily Stacy · Dallas, TXN7370ZOmaha Soaring Club Inc · Omaha, NEN7371Registered aircraftN73719Purdue Aviation LLC · West Lafayette, INN7371DLohse Teal K · Cordova, AKN7371LMcewen Michael Trustee · Overgaard, AZN7371PJsntg Inc · Wilmington, DEN7371TEmerald City Aircraft Leasing Inc · Port Orchard, WAN7371WVista I Inc · Smithville, OHN73726Wings Over Texas Holdings LLC · Denton, TXN73728Crowe Robert B · Del Valle, TXN7372JMccabe Colin · Frisco, TXN7372PArnold Matthew C · Alpine, CAN7372ZLong Island Soaring Assn · Yaphank, NYN73732Midway Capital Aviation Inc · Orlando, FLN7373DKramer William L · Big Lake, AK
Back to AD 87-10-06 R1