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.
N9088QGolf Foxtrot Yankee LLC · Kingston, NYN9088UPennington Daniel W · Rutland, VTN9089K&M Land Surveying Inc · Lincoln, NEN90898Nation Steven R · Hurricane, UTN9089CCrew Sourcing Inc · Wilmington, DEN9089HDavis Joseph S · Andalusia, ALN9089PDummer Donald W · Novato, CAN908AArcher Aero LLC · Wilmington, DEN908AFRobinson Craig M · Colfax, CAN908AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN908AZWingsleasing LLC · Wichita, KSN908BLBoudreaux Jacques P · Shreveport, LAN908CPCivil Air Patrol Inc · Maxwell Afb, ALN908DKNeilson Frank · Orlando, FLN908DRRhodes Dennis R · Taylorsville, GAN908ENEl Aviation LLC · Alpena, MIN908GDCorpus Terra Investments LLC · Hialeah, FLN908JDNash Gregg Lynn · New Waverly, TXN908MABlue Air Venture LLC · Gilcrest, CON908NDUniversity Of North Dakota · Grand Forks, NDN908QCCook Hugh Q · Aurora, CON908TBushby Harvey M · Minooka, ILN908VLBlue Waters Air Charters LLC · San Juan, PRN90908Charles Wilford W · Big Lake, AKN9090BHaynes Aviation LLC · Wetumpka, ALN9090PCatherwood Owen · Eugene, ORN9090WRyeco Inc · Lewes, DEN9090XTahaney David J · Fox Lake, ILN90912Snead Douglas A · Derby, KSN90919Allman Joseph S · Blackstone, VAN9091CYoung Gregory S · Riverside, CAN9091DCanton Logan J · Petersburg, AKN9091HCampbell Raymond · Box Elder, SDN9091PGalagan Robert · Lincoln Park, NJN9091VScheutzow David P · Medina, OHN9091YCsa Investments LLC · Wayne, PAN90922Blair Ernest J · St Thomas, NDN90928Skunberg Leonard T · Salmon, IDN9092CAdirondack Aviators LLC · Peru, NYN9092HWinemiller Stevie Dale · Swifton, ARN9092JRegistered aircraftN9092VHogan Roger C · Virginia Beach, VAN9092WLong Earl V III DBA · Wichita, KSN9093Zimsim LLC · Charleston, SCN90931Davies Donald K · Hastings, MNN90932Hall Air Inc · Weiner, ARN9093FArcher 93f LLC · Danvers, MAN9093JRichardson Harley T Jr · Mullins, SCN9093KPdg Leasing LLC · Maryland Heights, MON9093LBielamowicz John Kolbe · Waxahachie, TX
Back to AD 87-10-06 R1