AD 2011-23-07
Registered aircraft · 219
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:2011-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:2011-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:2011-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:2011-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.
N428JDDewberry Air LLC · Atlanta, GAN42DH58dh LLC · Atlanta, GAN445STNp Aviation II LLC · Atlanta, GAN449BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN454THG200 Aviation LLC · Gentry, ARN468JJPdl Holdings Fl LLC · Tampa, FLN469DMNac Flight Service LLC · Madison, MSN479PRNellie Navigation LLC · Naples, FLN480JJJem Aviation III LLC · Thomasville, NCN500AGCd 321 LLC · Cypress, TXN501RPPts As LLC · Reading, PAN503RPPts As LLC · Reading, PAN508RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN513RBBeasley Roger K · Austin, TXN513UBC Street Holdings LLC · Newport Beach, CAN518KHGolden Eagle Management LLC · Missoula, MTN530LDModena Aviation LLC · Leander, TXN531MBCaleah Acquisitions LLC · Savannah, GAN54CMGac Wings LLC · Boca Raton, FLN557GABank Of Utah Trustee · Salt Lake City, UTN573PTLoxodonta Aviation LLC · Vero Beach, FLN57RGBank Of Utah Trustee · Salt Lake City, UTN581SFFkm Enterprises LLC · North Oaks, MNN597NEFiwc26 LLC · El Paso, TXN597RBBaugh Aviation Services LLC · Orem, UTN598KDWildhorse Air II LLC · Minden, NVN5BCTsb Aviation Inc · Madera, CAN606HPMustang 99 LLC · Austin, TXN612FAGroup Project Eight LLC · Bountiful, UTN619KSBank Of Utah Trustee · Salt Lake City, UTN626LBBank Of Utah Trustee · Salt Lake City, UTN631DVCsc Delaware Trust Co Trustee · Wilmington, DEN650DHDrury Development Corp · Saint Louis, MON651DHDrury Development Corp · Saint Louis, MON65ERM G Investment Properties LLC · Van Nuys, CAN663SBKka Enterprises LLC · Flower Mound, TXN668TVentu Aviation LLC · Tampa, FLN671BP671bp LLC · Cypress, TXN672PSFort Stephenson Air LLC · Chattanooga, TNN674PGArthur J Gallagher (Illinois) LLC · Rolling Meadows, ILN679MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN67KPMarivest Support Services LLC · Pittsburg, KSN67LRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN682RVKr Escapes LLC · Wilmington, DEN688HLH&L 168 LLC · Las Vegas, NVN68HHoward Industries Inc · Laurel, MSN696FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN699DB699db LLC · Vienna, VAN700FAJet Flight LLC · Shreveport, LAN703MSHillpointe Aviation Fl LLC · Winter Park, FL
Back to AD 2011-23-07