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.
N9986SKaneaster Richard W · Port Orange, FLN9988FDel Rio Aviation Inc · Paso Robles, CAFirst renewal noticeN9988RSanders Flight Training Center Inc · Jasper, ALN9988VLenoir Aviation Club Inc · Lenoir, NCFirst renewal noticeN9988WHanneman Michael W · Abilene, TXN9989VPace Dusty · Pendleton, ORN9989WDnr Solutions LLC · Idaho Falls, IDN998BHayton James B · Sedro Woolley, WAN998BCSky High Homes LLC · Etna, WYN998CCBecker Mike DBA · La Grande, ORN998DMD & S Aviation LLC · Spring, TXN998FBRegistered aircraftAssigned, pending cancellationN998FGFlightgest Academy LLC · Morrisville, NCN998KCenter Charles C · Wasilla, AKN998MAWarhawk LLC · Latrobe, PAN998MMHardcastle Eric · Holly Springs, NCN998NCHoppe Joel A · Fort Myers, FLN998PWBaker Toby J · Guthrie, OKN998RASchubert Brothers Aviation Inc · Canandaigua, NYN998SBGiuseppe Rioni Volpato · Sacramento, CAN998SEUtter Albert · Fort Myers, FLN998TMSky West Aviation Inc Trustee · Albuquerque, NMN998TTHunton Hugh R II · Midlothian, TXN998WPReifers Todd R · Indianapolis, INN9990BAurora-Flight LLC · Commerce Township, MIN9990CFogarty Stephen J · Wasilla, AKN9990VCompass Aviation Inc · Shelby, NCN99917Anderson Cody Jon · Orono, MEN9991BTaft Leasing LLC · Bloomfield, NMN9991DNothum Robert G · Dixon, MON9991GSale Reported · Staten Island, NYSale reported, canceledN9991VSafeway Flying Club Inc · Denmark, WIN9992LLenz Lance J · Van, TXN9992VShipe Jacqueline M · Louisville, TNN9993DMunson Matthew C · Canby, ORN9993ECruise Flight Academy Inc · Dalton, GAN9993YStukenberg Brian · Byron, ILN99948Florida State College At Jacksonville · Jacksonville, FLN9994DKnudsen Ernest W Jr · Ennis, TXN9994GTre Aviation Corp · Wilmington, DEN9994UKaczmarek John F · Weatherford, TXN9994VWings Over Texas Holdings LLC · Denton, TXN9995CCullman Dan H · Kent, WAN9995RBig Sky Navigation & Flight Training LLC · Bristol, VAN9995UAero Cats Of New Hampshire LLC · Plainfield, NHN9996CHackwell Calvin · Enoch, UTN9996USapir Kfir · Las Vegas, NVN9997UGuth Giora · Lexington, MAN9997VBecker Philip J · Ocean Isle Beach, NCN9997YLehrer James R · Thief River Falls, MN
Back to AD 87-10-06 R1