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.
N9880YMerrick Shane · Redgranite, WIN98811Kadena Aero Club · Apo Ap, CAN98819Oxford Flying Club Inc · Oxford, CTN9881GFortenberry Robert N · Pascagoula, MSN9881KHickman David R · Port Orange, FLN9881PSale Reported · Spartanburg, SCSale reportedN9881QSky Drivers LLC · Lavalette, WVFirst renewal noticeN9881UChristensen Myra J Storms · Pierre, SDN9881VShackleford Developments Of Sc LLC · Mount Pleasant, SCN98824Civil Air Patrol Inc · Maxwell Afb, ALN9882DUsda Aphis Ws Atoc · Cedar City, UTN9882UNordbye Newell · Eden Prairie, MNN9883GLagor Mark D · Parshall, NDN9883PMinden Soaring Club Inc · Minden, NVN98840Aviator Air Flight School LLC · Grand Prairie, TXN98843American Patrols Inc · Midland, TXN9884DMartensen Marten · Anchorage, AKN9884GBarbour John P · Dexter, MON9884KSalt Air Inc · Wilmington, DEN9884PVandegriff Cody E · Eagle River, AKN9884VShockley James F · Loves Park, ILN9884YRoberts Colton C · Bluebell, UTN98851Jacques Jerry Joseph · Iliamna, AKN98853Registered aircraftN9885DBarney Jeff S · Fairbanks, AKN9885PTriple Cub Aviation LLC · Greenbush, MIN9885QAngel Aviation Inc · Peoria, AZN9885USchneider Fred M Jr · Fishkill, NYN9885VNix Jacob DBA · Johnson, KSN9885YCentral Air Parts Inc · Staunton, ILN9886CAlm Ronald · Kuna, IDN9886KSmart03 LLC · Kissimmee, FLN9886NHall Benton G · Plano, TXN9886VBognar John W III · Sardinia, NYN9886WLathem Emma K · Amarillo, TXN98873Laguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeN9887CLeonard Paul A Jr · Grand Beach, MIN9887DRegistered aircraftN9887LSkywarrior Flight Training Inc · Pensacola, FLN9887QTupelo Aeronautics Inc · Tupelo, MSN9887VDarby Holly M · Midland, TXN98887Jodkin Jason · Confluence, PAN9888CLoehde Thomas · Lolo, MTN9888GRegistration Pending · Atlanta, TXRegistration pending, pending cancellationN9888WSchlafer Antone · Lincoln, CAN98893Pape Jason C · Sykesville, MDN98896Two Tails LLC · Las Vegas, NVN9889DBorth Johnny D · Meade, KSN9889GWright Flight Inc · Tucson, AZN9889QTack-Morse Patricia M · Sweet Home, OR
Back to AD 87-10-06 R1