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.
N769ATTarragon Aircraft USA LLC · Pekin, ILN769GALong Island Aviators LLC · Seaford, NYN769GMN373hp LLC · Ladera Ranch, CAN769GSSkylar Aviation LLC · Hagerhill, KYN769JBGibson Randy L · Clinton, TNN769LZMontana 1204 LLC · Rock Valley, IAN769NDN769nd LLC · Sidney, MTN769RAMcclure Dennis N · Mcalpin, FLN76ADWerner Richard · Syosset, NYN76AHOrthoplane LLC · Kalamazoo, MIN76AMRosinbaum Daryl A · Waller, TXN76ATCarney Raymond L · Newton, ALN76AUHayes Michael Mckool · Destin, FLN76AWPacific Fleet Aviation LLC · Rochester, NYN76BCYackley Ranches · Onida, SDN76BDAndersen Diane M · Palm City, FLN76BKMohler Tucker A · Sautee Nacoochee, GAN76CRTownsend Joseph A · Buckeye, AZN76DHKarapelou James M · Allentown, PAN76DMHendrix Aviation Inc · Plantation, FLN76DRAppleget Edward L · Glendale, AZN76DSDeemer Jerry C · Granbury, TXN76DUL&P Of Mke LLC · Milwaukee, WIN76EHMitchell Matthew J · Penn Yan, NYN76EVKuhn Bernard O · Ripon, CAN76FCBlackhawk Holding Corp · Wilmington, DEN76FKSmith Fleet K IV · Stephens City, VAN76FR76 Freedom LLC · Greenville, INN76GCEdgerton Richard T · Arlington, WAN76GDCoulter Dennis W · Lincoln, CAN76GLSullivan Vincent E · Centerville, IAN76GZLankford Philip S · San Marcos, CAN76HJAmalong Timothy M · Tucson, AZN76HKDodson International Parks Inc · Rantoul, KSN76HRHeadwaters Flying Service LLC · Three Forks, MTN76HSDelgrosso Dennis W · Saranac, NYN76HYCarley Dale H · Griffin, GAN76JAJahawk Leasing LLC · Sugar Grove, ILN76JEReedy Dana J · Columbus, INN76JGSublett Farms · Ardmore, ALN76JKKrajewski Jason · Portland, ORN76JMWalton Daniel · Schaumburg, ILN76JNGross Charles C III · Mims, FLN76JVLeonardo David · Hollister, CAN76JYYoder Jeremy L · Sarasota, FLN76KKozak Joel L · Long Beach, CAN76KCCulhane Mark E · South Windsor, CTN76KDSchneider Aaron J · Chugiak, AKN76KFRegistration Pending · Grenada, MSRegistration pendingN76KRSorensen Bjarne K · Vero Beach, FL
Back to AD 87-10-06 R1