AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2156TJacksonville Navy Flying Club · Jacksonville, FLN2157FRineer Daryl · Pequea, PAN2157HMustang Sally Aviation LLC · Camden, SCN2157NC A R S Sales Inc · Denver, NCN2157YRegistration Pending · Northampton, MARegistration pendingN2158FCampbell Barrett Hunter · San Antonio, TXN2158SChristiansen Aviation LLC · Wilmington, DEN2158ZTribute Aero LLC · Rochester, MIN21591Kohn Aviation LLC · San Carlos, CAN2159PKiehn Real Estate LLC · Santa Barbara, CAN215AVNational Test Pilot School · Mojave, CAN215BCMetzler Alan J · Reedsville, PAN215CTahome LLC · Saint Petersburg, FLN215CACivil Air Patrol · Maxwell Afb, ALN215CDValiair Lc Trustee · Casper, WYN215CFHarter Ryan · Greenfield, INN215CSStein Curt · New Ringgold, PAN215DBHurst Jeffrey A Trustee · Tahoe City, CAN215DJGreat Plains Aviation LLC · Scott City, KSN215DWMoore David R · Granbury, TXN215ERAmerican Capacitor Corp · Irwindale, CAN215GRDesilva David I · Carolina, PRN215HRLld Inc · Sarasota, FLN215JCCavanaugh Air LLC · Addison, TXN215LPChristiansen Aviation LLC · Wilmington, DEN215MSMulcaire Jess E · Camp Verde, AZN215RCGulf Coast Aviation LLC · New Orleans, LAN215SMMyers Roy D · Naples, FLN215STNapoleon Christopher D · Allegany, NYN215TGWatson William P · Durham, NCN215TLLockard Theodore E Jr Trustee · Des Moines, IAN215UParagon Airplane Leasing Co · Fort Myers, FLN215WKaelberer Clyde · Montrose, MNN215ZAlpha Tango Aircraft LLC · Wilmington, DEN21605Chandler Air Service Inc · Chandler, AZN21608Mmt87 LLC · North Miami, FLN2160DSamper Katherine · Miami, FLN2160QSo Cal Leasing LLC · El Cajon, CAN2160THughes Johnny D · Meridian, MSN2161AHoyer Chase R · Jarrell, TXN2161PRegistered aircraftN2161WMatz Michael D · Hanna, INN2161XLake Riley Aviation Inc · Excelsior, MNN21627Beach David S Trustee · Amherst, NHN2162KApm Leasing LLC · Casper, WYN2162LN2162l LLC · Tyler, TXN2162REndthoff Wayne K · Beloit, WIN2162TVolantis LLC · West Fargo, NDN2162WHelicopter Applicators LLC · Pembroke, NHN2162XTaylor Express Investments Inc · Wilmington, DE
Back to AD 2006-10-21