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.
N2JAJadair International Inc · Port Washington, WIN2LYMagnolia Air LLC · Starkville, MSN300BRMach Tuck Aero Group LLC · Elkhorn, NEN300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKN300SQVortex Aviation LLC · Houston, TXN301CPWhy Not Fly Aviation LLC · Gainesville, VAN303ABMarc Inc · Bolton, MSN303CCSpectrum Aviation Inc · Wilmington, DEN303CGSolomon Mark Trustee · Wilmington, DEN303CMAdvantage Aviation Inc · Charlotte, NCN303DBBas Part Sales LLC · Greeley, CON303DKTrading Planes Inc · Wilmington, DEN303HLLao Che Airfreight LLC · North Weymouth, MAN303JPJep Inc · Clarksville, TNN303KJBrother Michael Andrew · Bedford, TXN303KSSmoky Hill Ag LLC · Healy, KSN303MBBas Part Sales LLC · Greeley, CON303PBPlane Fun Inc Tr Trustee · Snellville, GAN303WAWacker Logistics LLC · Naples, FLN303WJQualitair LLC Trustee · MichelstadtN303WWQualitair LLC Trustee · MichelstadtN306PMBc 414 LLC · Vineyard Haven, MAN307FMNorris Aviation LLC · Mansfield, TXN30EEEnterprises Aviation Inc · Piedmont, SDN30FBBmg Aviation Leasing LLC · Bloomington, INN30LTJuans Adios LLC · Newark, DEN30PTGas Aviation LLC · Decatur, TNN311BC311bc LLC · Channelview, TXN311BTBob Air LLC · Concord, MAN311CASouthern Wings LLC · Shreveport, LAN311JHHuaco Aviation LLC · Waco, TXN316WCEagle Aeronautics LLC · Chicago, ILN317MZValiair Lc Trustee · Casper, WYN31CLg & Gs Holdings LLC · Middletown, DEN31CULovaas Jean H Trustee · Crescent City, CAN31KDChinook Fibre LLC · Wilmington, DEN31MMPence Air LLC · Edinburg, VAN320SWEast West Investment Advisors LLC · Sandy Point, VAN3216MN3216m Inc Trustee · Carson City, NVN321CEGreen Eggs And Ham Aero LLC · Helena, MTN321JHSkidmore Gary DBA · Terreton, IDN322HAAir Flight Inc · Fort Lauderdale, FLN322RMPhillips George Thomas · Carson City, NVN323TJGuardian Wings LLC · Fredericksburg, VAN3249MHyannis Air Service Inc · Hyannis, MAN325KCMount Wilson Holdings LLC · Orange, CAN327MWW. Morrison Consulting Group Inc · Aliso Viejo, CAN3292MHyannis Air Service Inc · Hyannis, MAN333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN334NCarter-Muthana Aero LLC · Bakersfield, CA
Back to AD 95-09-13