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.
N9217KR & R Air Inc · Wilmington, DEN9217MMullenbach Arnold D · Tucson, AZN9217PGruber Joachim R · Elizabethtown, KYFirst renewal noticeN9217TRegistered aircraftN9217WMartin Joe T Jr · Chandler, AZN9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedN9218CArensmeyer Michael W · Longmont, CON9218DMaestas Jonathan M · Wright City, MON9218RFishe Flying Corp · Vero Beach, FLN9218SSurette Phillip · Vail, CON9218VTerrell Aviation Inc · Terrell, TXN9218WRitcheson Mark F · Tucson, AZN9218YHubble Boeing Development Corp · Gallipolis, OHN9219EStahl Randy F · Fort Benton, MTN9219HKful Flyers Foundation Inc · Fullerton, CAN9219KJones Robert M · Brooksville, FLN9219PChrastka Keith · San Angelo, TXN9219VChen Brian K · Bakersfield, CAN921AARegistration Pending · Deland, FLRegistration pendingN921BLLewis Bertrand V · Glendale, AZN921CBDavis David G · Cresson, TXFirst renewal noticeN921CTN921ct LLC · Elkton, KYN921DCCarlson Donald A III · Lexington, TNN921GDAir Charter Inc DBA · Culebra, PRN921JBC&Z Aero LLC · Des Plaines, ILN921JKShackleford Wayne D · Riverside, CAN921JMFlight Equity LLC · Fayetteville, ARN921KCRocket City Helicopters LLC · Brownsboro, ALN921KPCenturion N709jm LLC · Minneapolis, MNN921LCCrum Robert W · Lake Havasu City, AZN921LGHertz David · Dix Hills, NYN921LJGossett Chase · Centre, ALN921NDUniversity Of North Dakota · Grand Forks, NDN921PABird Acquisition LLC · Phoenix, AZN921PCProppe Karl H · Needham, MAN921RSSpry Mark W · Elkmont, ALN921SJDavis Brandon Grey · Huntsville, ALN921TAAtp Aircraft 4 LLC · Wilmington, DEN921TCBell Charles S · Fort Payne, ALN921TTRed Baron LLC · Middletown, DEN921UTumbleweed Leasing Co Inc · Salt Lake City, UTN921UN921un Ventures LLC · Mercer Island, WAN921WC7 Corp · Orlando, FLN921WJJones Wesley C · Yuba City, CAN921XPLengler Aviation LLC · Fort Myers, FLN922Tjk Enterprises LLC · Helena, MTN9220BSchmalenberger Jason R · Hebron, NDN9220CDixon Aviation LLC · Oakland, MDN9220DEllis Harvey Airport Inc · Guthrie, OKN9220MBeaty David · Santa Fe, NM
Back to AD 87-10-06 R1