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.
N9536HSampson Kelly J · Canby, ORN9536JGalata Aviation Services LLC · Autsin, TXN9536LFarris Thomas B · Henderson, NVN9536SExpress Aviation LLC · Philadelphia, MSN9536WOwen Christopher D · Molt, MTN95376Team K Outfitters LLC · Memphis, MON9537CArcher II LLC · Kenosha, WIN9537LPence Jeffrey S · Edinburg, VAN9537MWatts Brett M · Prescott, AZN9537QBoeing Empolyees Flying Assn · Renton, WAN9537SHowell Alice R · Bainbridge, GAN9537WOlson Douglas C · Buffalo, MNN95381Gray Dennis P · Le Roy, NYN95383Wolter Michael S · Dallas, TXN9538CCobb Janet · Saint Joseph, MON9538HK & L Air Inc · Brazil, INN9538WField James E · Kendallville, INN9539BThree Rivers Limousine Service Inc · Pittsburgh, PAN9539CNafziger Aviation Leasing LLC · Wittman, MDN9539DBohemia Aviation LLC · Niagara, WIN9539MPfaltzgraff George E A · Solon Springs, WIN9539PNichols Aviation LLC · Middletown, DEN953ACConeburripul Corp · Miami, FLN953BCCammarata Robert Jr · Greensburg, PAN953BLMeier James A · Lac Du Flambeau, WIN953CNEllison Craig · Sandpoint, IDN953DYNeiger Steven W · Portland, ORN953EPratt David E · Jefferson City, MON953GArcher Flight LLC · Wilmington, DEN953GBFunnemark Dennis F · Niceville, FLN953LCHustings Ross · Rockwall, TXN953MAGutierrez Francisco J · Laredo, TXN953SMBogen Alfred T · Brandon, MSN953SSSinor Delbert D · Ozark, MON953TEL A Mesa Ventures LLC · Denison, TXN953TFAir Fleet Holdings LLC · Missoula, MTN953TWEllison Craig M · Sandpoint, IDN953WTDragons Fly Aviation LLC · Lantana, TXN95402Registered aircraftN95403Deffenbaugh Dennis L · Langley, OKN95405Hovey Ryan R · Concord, VTN9540BFly8ma LLC · Big Lake, AKN9540DGibsons Gas Inc · Holland, NYN9540LCivil Air Patrol Inc · Maxwell Afb, ALN9540MBostrom Zachary J · Ballwin, MON9540PStuder Al C · Shelby, MIN9540WCarter Brian A · Paragould, ARN95418Selleck Stephen P · Colton, CAN95419Underwood William · Fargo, NDN9541KElliott Thomas W · Sarona, WI
Back to AD 87-10-06 R1