AD 95-09-13
Registered aircraft · 1,061
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:95-09-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-09-13')
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:95-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-09-13') 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.
N393MPDutch Indian Air LLC · Riverdale, CAN3968GWatkins Aviation LLC · Golden Valley, MNN39WHGolden Touch LLC · Kalispell, MTN3DJHatch Hyrum G · Chandler, AZN400ATAlpha Tango Aviation Inc · Middletown, DEN400BSMb Aviation Inc · Larue, TXN400FCCrosswind Enterprises LLC · Box Elder, SDN401SXHyannis Air Service Inc · Hyannis, MAN401TJHyannis Air Service Inc · Hyannis, MAN402BKN402bk LLC · Nantucket, MAN402HGHyannis Air Service Inc DBA · Hyannis, MAN402JHAir Flight Inc · Fort Lauderdale, FLN402RSTropical Transport Services Ltd · San Jaun, PRN402SAAlly Mohamed Yacoob · Fort Lauderdale, FLN402SBGlemone Airways Inc · Wilmington, DEN402VNHyannis Air Service Inc · Hyannis, MAN402VPVespa Power Products LLC · Visalia, CAFirst renewal noticeN402ZKAirplane One LLC · Miami Springs, FLN404CPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404DGSubgup LLC · Naples, FLN404ECSarah Express Airways LLC · Miramar, FLN404JRBowlin & Associates Inc · Clayton, GAN404NEFehlhaber Wolfgang M · Port Orange, FLN404NSJ + D Aviation Services LLC · Centerville, MAN404PJPrivate Jet LLC · Miami Springs, FLN4057CAberdeen Flying Service · Aberdeen, SDN406BKN406bk LLC · Nantucket, MAN406GAHyannis Air Service Inc · Hyannis, MAN406RCIsland Flights Inc · Wilmington, DEN409BKHyannis Air Service Inc DBA · Hyannis, MAN40MEUnlimited Boat Sales Inc · Page, AZN40RUMoore Terry Alexander Trustee · Adel, GAN40SKSides Family Management LLC · El Paso, TXN410AJSouthern Aircraft Consultancy Inc Trustee · Casper, WYN410NFMurphy Aviation Inc · Gilroy, CAN411ABAmerican Time Machine LLC · Edmond, OKN411CKFairchild Bill R · Dalhart, TXN411MZSongbird Air LLC · Lakewood, CON411VGMontala Investments LLC · Montgomery, ALN412BPMission Hardward Ltd Co · Savannah, GAN412CAAirswiss Inc · Wilmington, DEN413BMLee Aviation LLC · Sheridan, ARN413VVGardner John · New Hudson, MIN414AKValiair Lc Trustee · Casper, WYN414AMToucan Aviation LLC · Lafayette, LAN414ATCreekmore Arnold · Somerset, KYN414AVChoate Oilfield Services LLC · Hennessey, OKN414BTrojan Enterprises LLC · Dover, DEN414BBDougherty Forestry Manufacturing Ltd Co · Hinton, OK
Back to AD 95-09-13