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.
N58ZPCk Investor Inc · Lubbock, TXN596DMAirswiss Inc · Wilmington, DEN598ASAssociated Auction & Liquidation Co · Clarksburg, TNN598DMAirswiss Inc · Wilmington, DEN5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeN5CNLewis Gentry Holdings LLC · Orlando, FLN5ERMill Direct Textiles LLC · Rollinsford, NHN5NMNelson Jeffrey S · Darby, MTN5NNRkgrier LLC · Beckley, WVN5UTK&L Salty Air LLC · Stephenville, TXN600DCHerron Aviation Group LLC · Dexter, MIN600HCCessna 414a LLC · Portland, ORN600THN600th LLC · Fredericksburg, VAN602DCKeystone Xpress LLC · Rostraver Twp, PAN605DCT&C Aviators LLC · Green Cove Springs, FLN605SRPlane Fun Inc Tr Trustee · Snellville, GAN607JDJd 707 Air LLC · Edgerton, OHN608RCRichland Aviation Inc · Sidney, MTN609DSTj Air Holdings Inc · Wilmington, DEN60GMInternational Air Services Inc Trustee · Carson City, NVN6115CHat Investments LLC · Spartanburg, SCN6161XGolden Eagle Aircraft LLC · Boulder, CON6161ZSkybound Holdings LLC · Orlando, FLN616STK&S Flights LLC · Sweet Valley, PAN617CCRiley Livestock Inc · Mayfield, KYN618CAHyannis Air Service Inc · Hyannis, MAN619ACFeed Yard Industrial Solutions LLC · Amarillo, TXN61AJCoco Air Ltd Trustee · Wilmington, DEN61JV61jv LLC · Chuckey, TNN622TRL C A Inc · Alamo, CAN625JLTurbulent Returns LLC · Minneapolis, MNN626DRK And L Transportation LLC · Carterville, ILFirst renewal noticeN628JWJuliet Whiskey LLC · Roanoke, VAN629WMVortech LLC · Woodbury, NYN62JCChuoke Joseph P · Texas City, TXN630ADT Machine LLC · Livingston, MTN6315XEagle Aviation LLC · Morristown, TNN633MCSveen Jeffrey T · Aberdeen, SDN635MAAirswiss Inc · Wilmington, DEN63DBDelta Properties Llp · Nogales, AZN643WMBarham Investments LLC · Dexter, MON6486VVroom Engineering Inc · Tucson, AZN648SBHays Kelly · Dumas, TXN6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYN650BDV1vr LLC · Saint Louis, MON650DBValiair Limited Company Trustee · Casper, WYN650RMAcci Aviation LLC · Conway, ARN6561CTrtc Aviation LLC · Byron Center, MIN6578CPapoose Air II LLC · Wilmington, DEN657WMRegistration Pending · Carlsbad, NMRegistration pending
Back to AD 95-09-13