AD 2011-22-01
Registered aircraft · 1,167
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-22-01')
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-22-01')
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-22-01') 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-22-01') 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.
N618WFJetran LLC · Horseshoe Bay, TXN6192BGlacier Aviation LLC · Westlake, TXN619GVTrans-Exec Air Service Inc · Van Nuys, CAN620JHBank Of Utah Trustee · Salt Lake City, UTN620SYGreeneagles LLC · Salt Lake City, UTN621MDBide A Wee LLC · Newark, DEN622CKN622ck LLC · Sterling, VAN623TAL3 Harris Technologies Inc · Waco, TXN624BPWilmington Trust Co Trustee · Wilmington, DEN624BRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN625FJFertitta Entertainment Holdings LLC · Houston, TXN625GNPaper Airplanes 3 LLC · Scottsdale, AZN625SCStryker Corp · Portage, MIN626JEMmap III LLC · Houston, TXN626JJBank Of Utah Trustee · Salt Lake City, UTN626RAMavir LLC · Albany, NYN62AFAmerican Fidelity Corp · Oklahoma City, OKN62FFPsalm 52:8 LLC · Dover, DEN631VRDoheny Leasing Inc · Culver City, CAN633ABWilmington Trust Co Trustee · Wilmington, DEN636JSJrs Global LLC · Opa Locka, FLN640WBank Of Utah Trustee · Salt Lake City, UTN641GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN642GAGulfstream Aerospace Corp · Savannah, GAN645CCL3harris Technologies Flight Capital LLC · Greenville, TXN645EARegistered aircraftN-number assigned (import), not yet registeredN645LHL3harris Technologies Flight Capital LLC · Greenville, TXN646TBBoeing Co · Berkeley, MON647GDRegistered aircraftN-number assigned (import), not yet registeredN648JPRegistered aircraftN64MTWindtop Inc · Dallas, TXN6508Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN6509Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650CVVerde Capital Corp · Tempe, AZN650DYPj Holdco LLC · New York, NYN650FXFlexjet LLC · Cleveland, OHN650GWOzora Inc · Wilmington, DEN650HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650NB650 Nb LLC · Chicago, ILN650RHStratton Woods LLC · West Palm Beach, FLN650RVTvpx Ars Inc Trustee · North Salt Lake, UTN650VCU S Bank Na Trustee · Hartford, CTN650WWRegistered aircraftN650XAAramco Associated Company · Houston, TXN652BADs Advisors II LLC · Oak Park, ILN654FXMirasol Capital LLC · Cleveland, OHN655FXZeitgeist Capital LLC · Cleveland, OHN656TTBank Of Utah Trustee · Salt Lake City, UTFirst renewal notice
Back to AD 2011-22-01