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.
N919SWCorporate Flight Management Inc DBA · Smyrna, TNN919VEOrlando Plane Partners LLC · Orlando, FLN91KHRhema Bible Church Inc · Broken Arrow, OKN920EVSkywest Airlines Inc · St George, UTN920FJSkywest Airlines Inc · St George, UTN920SWCorporate Flight Management Inc DBA · Smyrna, TNN921EVSkywest Airlines Inc · St George, UTN921FJBank Of Utah Trustee · Salt Lake City, UTN922EVSkywest Airlines Inc · St George, UTN922FJBank Of Utah Trustee · Salt Lake City, UTN923EVSkywest Airlines Inc · St George, UTN923FJBank Of Utah Trustee · Salt Lake City, UTN923SWSkywest Airlines Inc · St George, UTN924FJBank Of Utah Trustee · Salr Lake City, UTN924SWSkywest Airlines Inc · St George, UTN925EVSkywest Airlines Inc · St George, UTN925FJBank Of Utah Trustee · Salt Lake City, UTN925SWCorporate Flight Management Inc DBA · Smyrna, TNN926ECJcpe LLC · Boston, MAN926EVSkywest Airlines Inc · St George, UTN926LRBank Of Utah Trustee · Salt Lake City, UTN926SSJcpe LLC · Boston, MAN926SWSkywest Airlines Inc · St George, UTN927EVFrontera Flight Holdings Inc · Dover, DEN927LRBank Of Utah Trustee · Salt Lake City, UTN927SWSkywest Airlines Inc · St George, UTN928EVSkywest Airlines Inc · St George, UTN928LRBank Of Utah Trustee · Salt Lake City, UTN928SWSkywest Airlines Inc · St George, UTN929EVSkywest Airlines Inc · St George, UTN929LRBank Of Utah Trustee · Salt Lake City, UTN929SWSkywest Airlines Inc · St George, UTN930SWSkywest Airlines Inc · St George, UTN931EVSkywest Airlines Inc · St George, UTN931LRBank Of Utah Trustee · Salt Lake City, UTN932EVSkywest Airlines Inc · St George, UTN932LRBank Of Utah Trustee · Salt Lake City, UTN932SWSkywest Airlines Inc · St George, UTN933EVSkywest Airlines Inc · Saint George, UTN933LRBank Of Utah Trustee · Salt Lake City, UTN934SWSkywest Airlines Inc · Saint George, UTN935LRBank Of Utah Trustee · Salt Lake City, UTN935SWSkywest Airlines Inc · St George, UTN936EVSkywest Airlines Inc · St George, UTN936SWSkywest Airlines Inc · St George, UTN937EVSkywest Airlines Inc · St George, UTN937SWSkywest Airlines Inc · St George, UTN937TABank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN938SWSkywest Airlines Inc · St George, UTN939SWSkywest Airlines Inc · Saint George, UT
Back to AD 2012-01-10