AD 75-23-07
Registered aircraft · 827
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:75-23-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-07')
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:75-23-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-07') 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.
N4032CKrs Aerial Inc · Galloway, OHN403DM403dm LLC · Indianapolis, INN40484Sunland Air Inc · Frederick, MDN4062ACessna 310n4062a LLC · Tuscaloosa, ALN4063QThin Air Inc · Hays, KSN4079CCalled To Care Residential Facility LLC · Avondale, AZN4090ATop Gun Aviation Group Inc · Santa Monica, CAN410WMFlying Life LLC · Middleburg, FLN411SMKonkel Bernard · Kalispell, MTN4141ALady Bird Of Rhinebeck LLC · Rhinebeck, NYN417EC417ec LLC · Sheridan, WYN41AYHunterdon Aviation Inc · Ringoes, NJN41LCBowen William A III · California, MDN4258CSonrise Aviation LLC · Portland, INN4264JBellamy Mark A · Freeville, NYN427CAChippewa Aerospace Inc · Gainesville, FLN428DLGiair LLC · Morristown, TNN42SSBas Part Sales LLC · Greeley, CON431BRLockyer Roch Jr · Austin, TXN433YHRegistration Pending · Stuart, FLRegistration pendingN43DW10-4 Aviation LLC · Waco, TXN4420MJohnson Capital LLC · Colleyville, TXN442AKKelly Aviation Inc · Tampa, FLN443LTValiair Ltd Co Trustee · Casper, WYN444HTTaktos Ltd · Corvallis, ORN444LJDsl Aviation LLC · Ronkonkoma, NYN444STPeterson Ocean Tours LLC · Pace, FLN44VKBates Management Inc · Woodstock, GAN4546QHarlow Jack M · Benbrook, TXN455TBSmith Loren D · Great Falls, MTN455XTreat-Yo-Self Confections Inc · Corona, CAN465DLKeystone Aerial Surveys Inc · Philadelphia, PAN466PJv Aviation LLC · Johnston, RIN466QBiziorek Thomas R · Harbor Springs, MIN474DBMr Restore Services Inc · Vero Beach, FLN474DLPrasad Sanjeev K · Las Vegas, NVN47BGVonweisenstein Thomas W · Brentwood, TNN4868AKlokner James B · Madison, WIN4905AAnderson Ryan Alexander · Minnetrista, MNN4927AGenx Aviation LLC · Leesburg, VAN4937JSwirsding David J · Chalfont, PAN4938AK E R Air LLC · Fort Myers, FLN4941AMartinello Domenic · Clarksville, TNN4948AKeystone Aerial Surveys Inc · Philadelphia, PAN4949ASw Air LLC · Denver, CON497JMBazzi Aviation LLC · Newark, DEN498DASmm Leasing LLC · Camp Verde, AZN4FAOgburn Benjamin R · Fernandina Beach, FLN4GKDalessandro Janet E · Park Falls, WIN4PJAnderson Richmond E Jr · Orlando, FL
Back to AD 75-23-07