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.
N16AUTulsa Air And Space Museum Inc · Tulsa, OKN16BJMarshall John Robert · Missouri City, TXN16CBBoecher Carl A · Morrison, CON16DLLincoln David · Henderson, NVN16DPNdmi Inc · Greeneville, TNN16DVDecathlon LLC · Herndon, VAN16ECSchnell Michael D · New Bremen, OHN16EDSimply Living LLC · Fort Myers, FLN16EMB J Air Ltd · Howard, OHN16FWSwain Kenneth C · Harvard, ILN16GAGuidance Helicopters Inc · Prescott, AZN16GHGreysky LLC · Smyrna, TNN16GLDuncan David · Colorado Springs, CON16HLPlane Fun Inc Tr Trustee · Snellville, GAN16HMRfs Aviation LLC · Greer, SCN16HWKelley John E · Bartlett, TNN16JCRl Equipment And Services LLC · Monument, CON16JMAlexander Co · Colleyville, TXN16JSMace Terry G · Saint James, MNN16KJJones Kevin M · Savannah, GAN16LCJohnson Neil D · Cincinnati, OHN16LDDodge Larry H · Hernando, FLN16LKOber John A · Candor, NYN16LWWalters Linn R · Malabar, FLN16MCHadachek Joshua L · Independence, ORN16MMGoff Bruce J · Williamstown, MAN16PMRiordan James · Kanab, UTN16PXSmith Howard Michael · Wynne, ARN16RAWesley Robert J · Chuckey, TNN16RCLake N16rc Partners LLC · Stamford, CTN16RHOppegard Nicholas D · Eagle River, AKN16RJParagon Airplane Leasing Co · Fort Myers, FLN16SCWestern Alaska Aircraft Leasing LLC · Pahrump, NVN16TTGeronimo Aerosport LLC · Dover, DEN16UPSkinner Norman G · Osceola, IAN16UTWhite Alan J · Fishersville, VAN16VLDaro Associates LLC · Mahwah, NJN16WHPrescott Scot · Alburgh, VTN16WYAbbott Thomas B · Portland, MEN16WZRud Gilman E · Coronado, CAN16XVOlson Mark D · Longmont, CON16XWJohnson Scott A · Laveen, AZN16YPSebastian Aero Services Inc · Guaynabo, PRN16YSSealing Edward L · Port Orange, FLN17019Reed James W · Boulder City, NVN1701CCleek Norris Eugene · Orland, CAN1701EValiair Limited Co Trustee · Casper, WYN1701ZInternational Air Services Inc Trustee · Carson City, NVN1702HHesston College · Hesston, KSN1702RDaniel Boone Flying Club Inc · Booneville, MO
Back to AD 2006-10-21