AD 97-06-06
Registered aircraft · 2,038
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:97-06-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-06')
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:97-06-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-06') 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.
N190RLCamair Leasing LLC · Granbury, TXN190SSJ&H Kramer Inc · Redwood City, CAN190TTAcme Jet LLC · Dover, DEN190WAAmeriflight LLC · Dallas, TXN190XTNextant Aerospace LLC · Cleveland, OHN191AVUas Transervices Inc · Boca Raton, FLN191AWCsi 135 Division LLC · Albuquerque, NMN191CSTvpx Ars Inc Trustee · North Salt Lake, UTN191CZPlanemasters Ltd · West Chicago, ILN191JRLocke-Lane Aviation LLC · Statesville, NCN191WAAmeriflight LLC · Dallas, TXN1924TUas Transervices Inc · Boca Raton, FLN1926A1926a LLC · Auburn, ALN192GAAlpine Aviation Inc · Provo, UTN192WAAmeriflight LLC · Dallas, TXN193CZPlanemasters Ltd · West Chicago, ILN193SUUas Transervices Inc · Boca Raton, FLN194GAAlpine Aviation Inc · Provo, UTN194TRExecutive Air Taxi Corp · Bismarck, NDN195AWCsi 135 Division LLC · Albuquerque, NMN195GLAlpine Aviation Inc · Provo, UTN196SCChickasaw Transport LLC · Santa Rosa Beach, FLN196WAAmeriflight LLC · Dallas, TXN197CANighthawk Air Systems Inc · Miami, FLN197GAAlpine Aviation Inc · Provo, UTN197SCCharlie Ninety Alpha LLC · Searcy, ARN197WAAmeriflight LLC · Dallas, TXN198AWCsi Aviation Inc · Albuquerque, NMN198GAAlpine Aviation Inc · Provo, UTN199BCAirco King LLC · Wichita Falls, TXN199CGGuardian Flight LLC · Lewisville, TXN199CZN199cz LLC · Milwaukee, WIN199DWAeon62 Holdings LLC · Plano, TXN199MHGsg Aviation LLC · Fort Lauderdale, FLN199NDDodson International Parts Inc · Rantoul, KSN199PLDodson International Parts Inc · Rantoul, KSN19EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN19RZUas Transervices Inc · Boca Raton, FLN1GFFlowers George D · Panama City, FLN1HXCentralav LLC · Lake Worth, FLN1LTWhite River Holdings LLC · Southaven, MSN1MARegistered aircraftN1NPNebraska Public Power District · Columbus, NEN1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNN1UCBas Part Sales LLC · Greeley, CON200ANAirtrex Registration Corp Trustee · Wichita, KSN200BTMid-South Regional Aviation LLC · Tunica, MSN200DAGambill Aviation LLC · Shreveport, LAN200EARegistered aircraftN200FMSapphire Air II LLC · Camp Hill, PA
Back to AD 97-06-06