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.
N8872PBlackburn Robert F · Georgetown, TXN8873DWroe Daniel C · Denton, MDN8873PTailwind Auditing Group LLC · Godley, TXN8873WGarza Reynaldo E · Corpus Christi, TXN8874CPleasant Valley Aviation Inc · Bellefonte, PAN8874JMelland Curtis B · Hazen, NDN8874NFisher Tim A · Stockton, MDN8874PWiebe Aron · Seminole, TXN8875DBishop Bill I · Cross Plains, TXN8875NMcclendon Charles Dowel · Lynchburg, VAN8875WBryan Greg · Oelwein, IAN8876JDestination Flyer LLC · Memphis, TNN8876MLohman Curtis · Shelby, MIN8876PWentworth Douglas G · Simpsonville, KYN8876VBlackburn Aviation Air LLC · Mesa, AZN8876YComanche 76y LLC · Waynesboro, VAN8877DSale Reported · Crystal, MNSale reportedN8877EParrot Flying LLC · San Francisco, CAN8877WAvery Aviation LLC · Picabo, IDN8877YVanhook Orville Richard · Somerset, KYN8878DHamilton Clyde Leon · Forest, VAN8878NCampbell Carl F · Amherst, NHN8878PHudson Albert Denning · Cornelius, NCN8878WBallard Tim · Roseburg, ORN8879EFlickinger Charles P · Hermitage, PAN8879JDaddona John M · Oakville, CTN8879NBesheer Susan Anita · Palm Springs, CAN8879YWelstad Blaine L · Newburg, NDN887BCAustin Aviation LLC · Boise, IDN887CCMr Dent Inc · Manheim, PAN887KJCf Aviation Trust LLC Trustee · Wilmington, DEN8880NAnderson Aviation LLC · Bulverde, TXN8880YPlane Fun Inc Tr Trustee · Snellville, GAN8881PIce Randall R · Pierre, SDN8881VLien Ronald N · Gilford, NHN8881WYellow Flyers Inc · Sioux Falls, SDN8882ERandall Christopher D · Northridge, CAN8882FCirrus Services Inc · Fargo, NDN8882VTop Aircraft Leasing LLC · Wilmington, DEN8882WFleet James Reginald Jr · Jacksonville, FLN8883JRegistration Pending · Midlothian, TXRegistration pendingN8883NWarner Alexander Douglas · Grand Rapids, MIN8883PFlynn James Jay · Seneca, SCN8883YYank N Bank LLC · Greeley, CON88847So-Do Holdings LLC · Monticello, GAN8884DJ C Aero LLC · Yelm, WAN8884NDubois Jerry · Oklahoma City, OKN8884WFolse Eldred · North Las Vegas, NVN8884YFlight Logistics LLC · Westerville, OHN8885HHoughton Patrick K · Villa Rica, GA
Back to AD 87-10-06 R1