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.
N604ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN605JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN609SKSkywest Airlines Inc · St George, UTN610LValiair Lc Trustee · Casper, WYN611ABPollard Spares LLC · Roanoke, TXN611SKSkywest Airlines Inc · St George, UTN612QXSkywest Airlines Inc · St George, UTN613SKSkywest Airlines Inc · St George, UTN614QXSkywest Airlines Inc · St George, UTN614SKSkywest Airlines Inc · St George, UTN618JJJj Challenger 620tm LLC · Wilmington, DEN620PJFth Acquisition Corp Vii · Richardson, TXNon-citizen corporation, flight hours not reportedN621DJNorth Point Aviation LLC · San Francisco, CAN625CASkywest Airlines Inc · St George, UTN627AFAmerican Fidelity Corp · Oklahoma City, OKN628EFSn 5024 Corp · Fort Lauderdale, FLN629SYSkywest Airlines Inc · Saint George, UTN638RWRepublic Airways Inc · Carmel, INN639RWRepublic Airways Inc · Carmel, INN640GRDodson International Parts Inc · Rantoul, KSN640RWRepublic Airways Inc · Carmel, INN641CADelta Air Lines Inc · Atlanta, GAN641RWRepublic Airways Inc · Carmel, INN642RWRepublic Airways Inc · Carmel, INN647RWRepublic Airways Inc · Carmel, INN648RWRepublic Airways Inc · Carmel, INN64LELuxury Jet Acquisitions Inc · Newville, ALN653RWRepublic Airways Inc · Carmel, INN654RWRepublic Airways Inc · Carmel, INN655RWRepublic Airways Inc · Carmel, INN656CASkywest Airlines Inc · St George, UTN656RWRepublic Airways Inc · Carmel, INN657RWRepublic Airways Inc · Carmel, INN658CASkywest Airlines Inc · St George, UTN659BRLogos Aviation Inc · Fort Lauderdale, FLN662BTBeautech Power Systems LLC · Dallas, TXN668CADelta Air Lines Inc · Atlanta, GAN669CADelta Air Lines Inc · Atlanta, GAN669LAFlash Enterprise LLC · Helena, MTN681HCIntermountain Medical Transport LLC · Salt Lake City, UTN685BRBank Of Utah Trustee · Salt Lake City, UTN686BRBank Of Utah Trustee · Salt Lake City, UTN693BRSkywest Airlines Inc · St George, UTN699BRSkywest Airlines Inc · St George, UTN700JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN701BRCorporate Flight Management Inc DBA · Smyrna, TNN701SKSkywest Airlines Inc · St George, UTN702PSAmerican Airlines Inc · Fort Worth, TXN702SKSkywest Airlines Inc · St George, UTN703PSAmerican Airlines Inc · Fort Worth, TX
Back to AD 2012-01-10