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.
N7169RBrock Charles Calvin Jr · Pendleton, SCN7169VPrh Farms Inc · Gettysburg, SDN716ACAlexandrov Boyan · Reno, NVN716CNNordquist Conrad · Jurupa Valley, CAN716CPCivil Air Patrol · Maxwell Afb, ALN716DCHesano Joseph M · Rockford, ILN716ERFly With Bruno LLC · Mountainside, NJN716GAtp Aircraft 9 LLC · Wilmington, DEN716GWTaylor David Clark · Springfield, VAN716HPState Of Ohio · Columbus, OHN716JJKeenum Jc · Loveland, CON716JLTrack D LLC · Talkeetna, AKN716KUrbanczyk Kirk M · Draper, UTN716LWWigley Eddie G · Howell, MIN716MCWing & A Prayer LLC · Wilmington, DEN716NDUniversity Of North Dakota · Grand Forks, NDN716PRChupond America Inc · Pittstown, NJN716RGGarrett Robert S · Dallas, TXN716RHPowers Alan J · Fayetteville, GAN716RLPerguson Robert Cole · Converse, TXFirst renewal noticeN716RSSprouse Ronald E · Port Orchard, WAN716SBDirect Gulf Access LLC · Springfield, MON716SPExec 1 Aviation II LLC · Ankeny, IAN716TCCentral Airlines Inc · Leawood, KSN7170GSs Skyways LLC · Becker, MNN7170PDalton Dennis P · Walsenburg, CON7170RBrown Joshua A · Fayetteville, GAN7170UWorley Ronald W · West Jefferson, NCN7170VKrack John L Trustee · Fridley, MNN7170WMontana Thomas · Port St Lucie, FLN7171FFriedrich Richard L · Georgetown, TXFirst renewal noticeN7171QMcnamara Bradley W · Seattle, WAN7171RYoungblood Steven H · Gilmer, TXN7171YHeinrich Steven W · Conroe, TXN71728Guskea Andrew E · Jericho, VTN7172PBarksdale Kevin L · Moore, OKN7172QRounds Agronomy LLC · Pierre, SDN7172UMark21-Charlie LLC · Brownsburg, INN7172VGanji Borna · West Windsor, NJN7172WSkrypai Vladislav · Poplar Grove, ILN7173BEavenson Daniel Scott · Ripon, CAN7173GSale Reported · Haiku, HISale reportedN7173QWesterly Av Group LLC · Westerly, RIN7173RRushton George E · Clinton, MIN7173WCastro Joaquin H · Wellington, FLN7173ZAir Kraft Spraying Inc · Timber Lake, SDN7174BMercil Richard · Grand Forks, NDN7174GMaloney John T · Deer Park, NYN7174KBracarelli Lisa A · Big Lake, AKN7174UVondross James B · Portland, OR
Back to AD 87-10-06 R1