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.
N1250HPhelps Lee D · Juneau, AKN1250JFranchise Aviation LLC · Sparta, NJN1250KChristiansen Aviation LLC · Wilmington, DEN1250PThreeville LLC · Warner Robins, GAN1250UPiper Aircraft Inc · Vero Beach, FLN1251XStephens Donald W · Social Circle, GAN1252EStedje Timothy M · Gruver, TXN1253TDellemonoche Dennis R · Tabernacle, NJN1254DAmeriflyers Of Texas Inc · Addison, TXN1254JWidener William J · Chillicothe, ILN1254TStewart Doug A · Indianola, NEN1255CHaslett Lisa L · Vinita, OKN1255SSmith David J · Broken Arrow, OKN1255XThomas Russell Robert · Alhambra, CAN1256CC177 Heavy LLC · Colfax, NCN1257XGoodman Archie · Mart, TXN1258QSiner John R · Kingsport, TNN1258XCompton Nathaniel Brandon · Fredericksburg, VAN12595Cornell Terry Jason · Bloomsburg, PAN1259AHigh Exposure Inc · Wilmington, DEN1259DBrown Nicholas J · West Valley City, UTN1259XSpencer H Brandon · Tampa, FLN125ABTkc Aviation LLC · York, SCN125AHPray Ricky Lee Trustee · Woodland Hills, UTN125AKBaize Equipment LLC · Crawford, TXN125AMMuhs Alan · Tucson, AZN125EMoir Jeffery K · Newhall, CAN125EBBlanks Eugene H III · Marion, MSN125EXWurster Gregory J · Creston, IAN125GMDavid Robert · Oatman, AZN125HAK-14 Squadron LLC · Santa Fe, NMN125HSHenderson State University · Arkadelphia, ARN125HUWyatt Gregory P · Billings, MTN125JABillmans Inc · Cut Bank, MTN125JDLeppien John C · Alma, MIN125KCOtto Pilot Aviation LLC · Midland City, ALN125LSchlamer Mark A · Campbellsport, WIN125LARussell Aviation LLC · San Diego, CAN125LGWheat Travis W · Henderson, NVN125MDMaryland Aviation Administration · Bwi Airport, MDN125MGHillsboro Aero Academy LLC · Hillsboro, ORN125MKGalloway Kenneth L · Greer, SCN125MLL3 Cts Airline Academy · Sanford, FLN125MSRegistered aircraftN125PJSpencer Aviation Services LLC · Sanger, TXN125RMGurtman Samuel · Deerfield, ILN125RSAlexander William F · Chapmansboro, TNN125SEDyer John F · Spring, TXN125SLSlingshot Aviation LLC · Chandler, AZN125TWSmith Susan · Scottsdale, AZ
Back to AD 2006-10-21