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.
N6922JSystematic Management And Flight Training LLC · Kankakee, ILN6922NPetrie Chris · Titusville, FLN6922UStrategic Aviation Assets LLC · Havre, MTN6922WRobirds Ryan E · Wheelersburg, OHN6923BWitzel John F Jr · Frenchglen, ORN6923DCline Patrick G · Granbury, TXN6923NTurner William H · Parkersburg, WVN6923PLopez Ruben Arellano · Nogales, AZN6923QWelch William Trustee · Washington, UTN6924HJeea Aviation LLC · Tyler, TXN6924PLauderback Lee L · Fort Collins, CON6924QPag Air LLC · Concord Township, OHN6924USchleisman Terry J · St George, UTN6924VBramer Aviation LLC · Middleburg, PAN6924WAlpha 3 LLC · Troy, KSN6925NFollrath Rick C · Ludington, MIN6925UDurocher Michael G · New Hudson, MIN6925VMay Michael S · Axtell, NEN6926DGibson Christopher R · Natchez, MSN6926HJust Plane Adventures Inc · Crystal Lake, ILFirst renewal noticeN6926NTurtle Mountain Air LLC · Bottineau, NDN6926PSkyways Group LLC · Greensboro, NCN6926UCreed Stephen R · Fort Worth, TXN6926WCola Air LLC · Irmo, SCN6927JClear2fly Aerospace LLC · Daytona Beach, FLN6927NFlying High LLC · Gore, VAN6927QIowa Military Aviation Heritage Museum · Ankeny, IAN6927UJones Robert Y · Alba, TXN6928DRegistration Pending · West Yellowstone, MTRegistration pendingN6928HMaya Air Services LLC · Lee, NHN6928NToysformud LLC · Missoula, MTN6928POwen Colin Jc · College Station, TXN6928VSky West Aviation Inc Trustee · Albuquerque, NMN6928WHammons Daniel G · Vadnais Heights, MNN6929DJohnson Timothy D · Chapel Hill, NCN6929UEisenhardt Scott · Milwaukee, WIN6929VHerzog Property Management LLC · Fergus Falls, MNN692ACMarshall Carol A · Lees Summit, MON692ASJgm Aviation LLC · Spring, TXN692CFG&M Aircraft Inc · Wheat Ridge, CON692DWBroyles Danny Keith · New Castle, INN692HMReagan Jason E · Sevierville, TNN692LHChristiansen Aviation LLC · Wilmington, DEN692MADevine James W · Columbus, OHN692SEmley Steven Allen · Port Angeles, WAN692SPSmith Holdings Inc · Wilmington, DEN692TBJenkins Clifford C · Shidler, OKN6930JSkypark Aero Club Inc · Troy, OHN6930VMatisko Michael J · Newburgh, INN6930WFlat Out Aviation LLC · Mercer, MO
Back to AD 87-10-06 R1