AD 2007-08-08
Registered aircraft · 12,447
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:2007-08-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-08-08')
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:2007-08-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-08-08') 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.
N1028WArt Air Partners LLC · Louisburg, NCN102CCPj Squared LLC · San Antonio, TXN102FAMedic Choppers LLC · Springdale, ARN102HLKopp Michael · Reno, NVN102JMHeld John S · Cincinnati, OHN102PSHunt Jimmie · Leary, GAN102QAir N Travel LLC · Cannelburg, INN102RBLeuszler Robert L · Lenexa, KSN102SBfb Enterprises LLC · Larned, KSN1030WChalupa Air LLC · Dover, DEN10319Battle Creek Aero Club Inc · Kalamazoo, MIN1031WBilco Air LLC · Danville, ILN1032WOhlinger Mark A · Copley, OHN1033WPunci Aviation II LLC · Port Washington, WIN1036TSlaughter Terry D · Perryton, TXN1037BSky West Aviation Inc Trustee · Albuquerque, NMN1039A39a LLC · Sioux Falls, SDN1039TJera · Johnson City, TNN103EYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN103LHKavalair LLC Series D · Marion, MTN103SEClear Prop Aviation LLC · Sioux City, IAN103SMHermack John F · Toms River, NJN103WWWilkin Richard G · Monticello, ILN1040TTen Forty Tango LLC · Wichita, KSN1040WFoolish Pleasure Aviation Inc · Lewes, DEN1042RSale Reported · Los Angeles, CASale reportedN1043WLatitude Aviation LLC · Cedar Rapids, IAN1044WAngier 66 LLC · Durham, NCN1045WButler Richard S · Poplar Grove, ILN1047W1047w LLC · Oakland, TNN104FMEide Machinery Sales Inc · Minneapolis, MNN104LARegistered aircraftN104MMBaron 104mm LLC · Rohnert Park, CAN104WWJarosak Peter J · Valparaiso, INN1050TThrash Scott · Hesston, KSN1054WHeavers George S · Oakland, CAN10554T34sum LLC · Lake In The Hills, ILN1057WMaisano Abby · Hendersonville, TNN1058RWindle Air Baron LLC · Lynchburg, VAN105BMatthews George W · Hillsboro, OHN105FADebbie Air LLC · Perkasie, PAN105XSaalwaechter John J · Lebanon, INN1060RCooper Don F · Great Falls, VAN1060WHarvey Ara Jr · Hernando, MSN1061DCcr Aviation LLC · Summit, NJN1061FFoxtrot Flight LLC · Clarksdale, MSN1061WHollinshed Thomas O · Fayetteville, NCN1062WSale Reported · Douglas, GASale reportedN1063WDakota Land LLC · Simms, MTN1064CBayside Development LLC · Bellingham, WA
Back to AD 2007-08-08