AD 2000-01-16
Registered aircraft · 2,711
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:2000-01-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-01-16')
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:2000-01-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-01-16') 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.
N26156Hyannis Air Service Inc · Hyannis, MAN2615GHyannis Air Service Inc DBA · Hyannis, MAN2615QVenture Air Solutions Inc · Opa Locka, FLN2617NFlightcentrx LLC · Peachtree City, GAN2618LFl & J Air Corp · West Orange, NJN2618VPlatz James · Auburn, MEN2619GDodson International Parts Inc · Rantoul, KSFirst renewal noticeN2619LAircraft Holding Solutions LLC Trustee · Newark, DEN2619Z4j Air LLC · Cartersville, GAN261ALCkm Aircraft Holdings I LLC · Mandan, NDN262MCAerospace Trust Management LLC Trustee · Wilmington, DEN2635XN2635x LLC · Eau Claire, WIN2638XSoftware 2000 Inc · Arroyo Grande, CAN2641PChandler David G · Phoenix, AZN2642ACronin LLC · Jacksonville, FLN2642YStallings Ted W · Seldovia, AKN2644VCrosby David · Potomac, MDN2649ZHyannis Air Service Inc · Hyannis, MAN264DCAirdvm LLC · Rcho Sta Marg, CAN26514Hyannis Air Service Inc · Hyannis, MAN2651SHyannis Air Service Inc · Hyannis, MAN26533Txoperation LLC · Fort Scott, KSN26560Rockslide Analytics Inc · Livermore, CAN2657GB & K Leasing Inc · Nantucket, MAN2657NLoreto Aviation LLC · Wahoo, NEN26588Golden Aero LLC · Tarpon Springs, FLN2658ZVirtue Genetics LLC · Cedar Rapids, IAN265PCSilver Eagle II LLC · Carson City, NVN265RGHerron Aviation Group LLC · Dexter, MIN2660UUnited Front Holdings LLC · Laguna Hills, CAN2664Lcj Holdings LLC · Youngsville, LAN2664FWisconsin Aviation Inc · Watertown, WIN2664LAce Airways LLC · Quincy, WAN2666DDrda Enterprises LLC · Denver, CON2666JA-Leasing · Dayton, OHN2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN2669NWilliamson Benjamin J · Morgan Hill, CAN2673BM & N Of Alabama LLC · Magnolia Springs, ALN2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKN2676BKero Jet Corporation · Montgomery, TXN2676RStauter Michael D · Idabel, OKN2676YHands Holdings · Newark, DEN267CAHyannis Air Service Inc DBA · Hyannis, MAN2688DB2 Air LLC · Pierre, SDN2688MAlcyone Trust Corp Trustee · Wichita, KSN2688XDw Hamm Consulting LLC · Malibu, CAN2689DRegistration Pending · Greenwood, MSRegistration pendingN2689GShandog Air LLC · Ashland, KYN2689TGuillon Inc · Chico, CAN268JBIn Tune Entertainment Inc · Scottsdale, AZ
Back to AD 2000-01-16