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.
N941DPOzer Cenk · Sequim, WAN941DRCrandall Randy M · Elbert, CON941GArcher Flight LLC · Wilmington, DEN941JWMoses Aviation Services LLC · Uvalde, TXN941LFMott Christopher · Punta Gorda, FLN941MPHill John D · Reno, NVN941RPHarvey Howard R · Castle Rock, CON941RVDji LLC · Cairo, GAN941TLandings At Quonset Airport LLC · Exeter, RIN941TADo Fly Aviation LLC · Silverdale, WAN941TWHodge Flight Services LLC · Pittsburg, CAN9420EAero Quest LLC · Costa Mesa, CAN9420NSpace Cadets Inc · El Cajon, CAN9420VAerologic LLC · Yorktown, VAN9421DJeff Air Pilot Services LLC · Shelbyville, INN9421EStroemsvik Kristian · Strasburg, VAN9421JSmith Robert Martin Jr · Port Saint Lucie, FLN9421NMitzoom Montana LLC · Lakeside, MTN9421VKohler Robert · Gilroy, CAN9422WEagle Wings Aviation Inc · Cornell, ILN9423BDrean Alelandre C · Ajo, AZN9423FAvex Holdings Heli Inc · Lewes, DEN9423JDt Pralle Enterprise Inc · Hampton, IAN9423KThompson Shane E · Warroad, MNN9423NCox Ricky L · Bell Buckle, TNN9423VLevin Robert G · Roseburg, ORN9424DBranch Clayton L · Winfield, KSN9424EAero Equities LLC · Ventura, CAN9424FOwens Mark T · Zionsville, INN9424WWilliams Ronald W · Prescott, AZN9425HWingsleasing LLC · Wichita, KSN9425JWachusett Flying Club Inc · Princeton, MAN9425NSpaniol Mark · Lula, GAN9425VEcaviators LLC · Wilmington, DEN9425WPopejoy Arthur T · Hanford, CAN9426EDarcy Aviation LLC · Danbury, CTN9426J4hx LLC · Dallas, TXN9426NClodfelter Chet · Roachdale, INN9426VTwo Guys One Plan LLC · Clermont, FLN9426WTitan Aero LLC · Little Rock, ARN9427NSchool Board Of Bay County Fl · Panama City, FLN9427PPaul Burrell Aircraft LLC · Spring, TXN9427VBrack Enterprises LLC · Indianapolis, INN9428FBargo Aviation Services LLC · Crittenden, KYN9428NYatteau Michael G · Woodbridge, CAN9428VMcconnaughhay Ken · Searcy, ARN9428WHodge Steve · Denison, TXN9429VFrankel Daniel A · Madison, OHN942BBSeibert Joseph John · Cincinnati, OHN942CMalavolti Ethan J · Terre Haute, IN
Back to AD 87-10-06 R1