AD 2012-01-10
Registered aircraft · 702
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:2012-01-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-01-10')
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:2012-01-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-01-10') 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.
N776MSWilmington Trust Company Trustee · Wilmington, DEN777GUGug LLC · Doral, FLN778RHWilmington Trust Co Trustee · Wilmington, DEN779RNWilmington Trust Co Trustee · Wilmington, DEN782SMWilmington Trust Co Trustee · Wilmington, DEN783LCWilmington Trust Co Trustee · Wilmington, DEN783MMMandalay Resort Group LLC · Las Vegas, NVN785BRWilmington Trust Co Trustee · Wilmington, DEN785MMMirage Resorts LLC · Las Vegas, NVN786SMWilmington Trust Co Trustee · Wilmington, DEN7886Polar Bear Express II LLC · Las Vegas, NVN788CJWilmington Trust Co Trustee · Wilmington, DEN789SSWilmington Trust Co Trustee · Wilmington, DEN790MKWilmington Trust Co Trustee · Wilmington, DEN792JBWilmington Trust Co Trustee · Wilmington, DEN794JHWilmington Trust Co Trustee · Wilmington, DEN794SCAloft Aviation Services LLC · Spartanburg, SCN798CCWilmington Trust Co Trustee · Wilmington, DEN7PSInnovation First Transportation Inc · Greenville, TXN800WCKpat LLC · Menlo Park, CAN805AYLogos Aviation Inc · Fort Lauderdale, FLN807DDFalcon Aviation Z LLC · Great Neck, NYN80DXSsc Enterprises LLC · Camarillo, CAN810DWings Of Time LLC · Carlsbad, CAN810GT8ten LLC · Tulsa, OKN810MDUmb Bank Na Trustee · Salt Lake City, UTN813JATrademark Aviation LLC · Camden, DEN813LSLove Airlines LLC · Dallas, TXN813MSCypress Cove Air LLC · Phoenix, AZN814PSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN815MDUmb Bank Na Trustee · Salt Lake City, UTN818AFCorbin Aviation LLC · Durant, OKN818MDUmb Bank Na Trustee · Salt Lake City, UTN819AYSlate Crj Acquisitions 1 LLC · Johnstown, PAN820ASBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN820AYSlate Crj Acquisitions 1 LLC · Johnstown, PAN821AYLogos Aviation Inc · Fort Lauderdale, FLN823AYFrontera Flight Holdings Inc · Dover, DEN823KDEast Shore Aviation LLC · Fort Lauderdale, FLN823MDUmb Bank Na Trustee · Salt Lake City, UTN824AYBeautech Power Systems LLC · Dallas, TXN824MDUmb Bank Na Trustee · Salt Lake City, UTN825AYFrontera Flight Holdings Inc · Dover, DEN825SGPlane Fetch Charter LLC · Anaheim, CAN826AYSlate Crj Acquisitions 1 LLC · Johnstown, PAN827AYLogos Aviation Inc · Fort Lauderdale, FLN828WGWg Aero LLC · Anchorage, AKN829AYFrontera Flight Holdings Inc · Dover, DEN831AYBeautech Power Systems LLC · Dallas, TXN832AYBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2012-01-10