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.
N61953Smith Gregory D · Kalamazoo, MIN6195DTieszen Randal · Madison, ALN6195JStandeford Thomas L · Lancaster, OHN6195WWillis Lee A · Roanoke, VAN61960Dockins Jamie L · Athol, IDN61962Becker Jeremy R · Anchorage, AKN61967Pereira Jailton · Elizabeth, NJN61969Registered aircraftN6196DJeff Air Pilot Services LLC · Shelbyville, INN6196GFirst Air Service LLC · Show Low, AZN6196JArcher Aviation LLC · Jesup, IAN6196LFiala Frederick P · Kingwood, TXN6196VRegistered aircraftN6196WDechaine Anthony L · Wyoming, MNN6196ZH&H Ag-Aviation Inc · New Underwood, SDN6197Nixon David W · Waverly, KYFirst renewal noticeN61971Bayport Alumni Recreational Flyers LLC · Shirley, NYN61972Smtm Holdings Inc · Wilmington, DEN61973School Data Solutions Inc · Spokane, WAN61974Proclaim Aviation Ministries · Worthington, MNN61975Fern Sky LLC · Monroe Township, NJN61977Rdr Racing Inc · Latta, SCN61979Maciak Michael · Center Conway, NHN6197JN6197j LLC · Dallas, TXN6197LRanger Airfield Foundation · Ranger, TXN6197PMclain James I · Bokeelia, FLN6197ZClermont Management Services Inc · Marietta, GAN61982Airwatch LLC · Santa Rosa, CAN61985Wiltshire Henry C Jr · Plymouth, MAN6198FFox Aviation LLC · Glencoe, ALN6198JBess Michael S · Niceville, FLN6198MPapa Bear Adventures Inc · Bethel, AKN6198WCherry Creek School District No 5 · Greenwood Village, CON61990Bauman William O · Abbeville, SCN61991Keime Parker · Show Low, AZN61994Mohawk Flying Club Inc · Ada, MIN6199BD & S Aviation LLC · Spring, TXN6199JReece Donald E · Odessa, FLN6199LBoddy Derrick M · Aiken, SCN6199SKilo Tango Aviation LLC · Watford City, NDN6199XH&S Aviation LLC · Chesapeake, VAN619ABAvenge Holdings LLC · Ashburn, VAN619AGUnited States Air Force · Colorado Springs, CON619BGRegistered aircraftN619BLPacific Fleet Aviation LLC · Rochester, NYN619CBBeers Aviation LLC · Cedar, MIN619CCDarkhorse Aerospace Holdings LLC · Tampa, FLN619FTParsley Thomas B · Downingtown, PAN619JSHeintz Ludwig C · Covington, LAN619KADavidson Dion · Sandy, UT
Back to AD 87-10-06 R1