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.
N8950UManley Steven T · Dallas, TXN8950WEthington Scott · Emmett, IDN8951DChadwick Stewart · Yuba City, CAN8951JMoehle Colleen M · Lincoln, ILN8951PJames Donnie E · Collinsville, ALN8952CZell Zulu LLC · Greensboro, NCN8952NCircle K Supply Chain Solutions LLC · Knoxville, TNN8952PBreckenridge Lester James Jr Trustee · Appleton City, MON8952WPollock William J · Agawam, MAN8953DVassal Ministries · North Pole, AKN8953PTendie Time Flying LLC · San Diego, CAN8953WKinser Aviation LLC · Guthrie, OKN8954CTeamco Aviation LLC · Saint Petersburg, FLN8954NSabbagh Mouin F · Missouri City, TXN8954PKramer Kartie K · Mckinney, TXN8955NRichart Nicholas J · Clever, MON8955PPropwash LLC · Princeville, ILN8955WSides Michael E · Bartley, NEN8955YCarter Howard A III · Stafford, VAN8956Martini Philip D · Bethel Park, PAN8956JBays Bob D · Jasper, MON8956WHalleck Brandon R · Terre Haute, INN8956YDark Side Aeronautical Inc · Wilmington, DEN8957CTracon Aviation LLC · Winter Springs, FLN8957JAirplane LLC · Farmington, UTN8957NN8957n Inc · Wilmington, DEFirst renewal noticeN8957PCreedon John · Mc Cormick, SCN8957VN8957v LLC · Fort Lauderdale, FLN8958English John H · Pittsburg, TXN8958CWinter John T · Tucson, AZN8958DPoulton Daniel D · Belton, SCN8958JDavis William M · New Lenox, ILN8958PVan Dyke David M · Portland, ORN8958VHyldburg Aviation Inc · Plymouth, MAN89594Executive Aviation LLC · Peoria, AZN8959JRegistration Pending · Fairmont, WVRegistration pendingN8959PMosel Properties LLC · Marrero, LAN895AGProffetty Stephen D · Bridgewater, MAN895DSGuida Associates Consulting Inc · Sandpoint, IDN895TCHeisecke Raul Torres · Tyler, TXN895VSpurlock Ricky DBA · Jensen, UTN8960CChristensen Todd S · Wasilla, AKN8960JRegistered aircraftFirst renewal noticeN8960NSkyriders Inc · Pocatello, IDN8961CHuguenard Jefferson · Alpharetta, GAN8961PRegistered aircraftN8961VHampton Flying Services LLC · Portsmouth, NHN8961ZHein-Reece Linda K · Shelton, WAN8962FEmbry Aero Ltd · Greenville, ILN8962JStory Allen D · Arlington, TX
Back to AD 87-10-06 R1