AD 2022-08-13
Registered aircraft · 3,069
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:2022-08-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:2022-08-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:2022-08-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:2022-08-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.
N1983XSouthern Airways Pacific LLC · Addison, TXN198LAVissair LLC · Rigby, IDN199CGGuardian Flight LLC · Lewisville, TXN199KQBridger Aviation Services LLC · Belgrade, MTN199YMicnic King Air LLC · Port Richey, FLN19CXSingle Windmill Ranch LLC · Austin, TXN19TXPerry James · Monroe, WAFirst renewal noticeN1NGLewis Aeronautical LLC · San Antonio, TXN1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNN1TCMarcare Aviation LLC · Gardnerville, NVN1TQWilmington Trust Co Trustee · Wilmington, DEN1VXMid America Sprayers Inc · Johnson, KSN20059Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2007UBank Of Utah Trustee · Salt Lake City, UTN200HKHck Aviation LLC · Jupiter, FLN200KQBridger Aviation Services LLC · Belgrade, MTN200KSKapowsin Air Sports Ltd · Shelton, WAN200MFMissionary Flights & Services Inc DBA · Fort Pierce, FLN200NDNorth Dakota Department Of Transportation · Bismarck, NDN200NWViking Transport LLC · Saint Louis Park, MNN200NYNew York State Police · Latham, NYN200UWTrustees Of The University Of Wyoming · Laramie, WYN200WPIdplane LLC · Boise, IDN200XLCondor Aviation LLC · Bethlehem, PAN2019PAgricultural Air Services LLC · Jupiter, FLN201GLAlpine Aviation Inc · Provo, UTN2022YPinecliff Aerial Inc · Camilla, GAN202FHTr Flying Service LLC · Milan, MNN202UXAlpine Aviation Inc · Provo, UTN2032KKing Ag Leasing Inc · Sudan, TXN2033RLj Leasing LLC · Cardington, OHN2035EGibson Flying Service Inc · Marianna, ARN2038QAt402 LLC · Banquete, TXN203KQBridger Aviation Services LLC · Belgrade, MTN203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKN203TASouthwest Aviation Specialties LLC · Tulsa, OKN2040EWeaver Flying Service Inc · Quincy, WAN2045GOught 9 LLC · East Helena, MTN2047VWilliamsburg Air Service Inc · Kingstree, SCN2049KUas Transervices Inc · Boca Raton, FLN204PEWorsham Farms Flying Service Inc · Camilla, GAN204WState Of Wisconsin · Madison, WIN20527Tr Flying Service LLC · Milan, MNN20551Lane Christopher A · Lakeland, GAN205RMLissie Flying Service Inc · Lissie, TXN2066EEdwards Flying Service Inc · Leland, MSN2067BAgricair Leasing LLC · Bancroft, WIN206KQDc3 Properties LLC · Sacramento, CAN2072DPadgett Ag Rotors LLC · Missoula, MTN2076BArrowhead Aviation LLC · Louisville, AL
Back to AD 2022-08-13