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.
N1462JWilson Donald R · Sterling, ILN1463FSun Aircraft Management LLC · Ormond Beach, FLN1464CEdb Air Inc · Wilsonville, ORN1464TSiedentopf Zyurelaie Indiana · Yelm, WAN1465JMartin Chris J · Zeeland, MIN1465TCaudle Tommie A · Bentonville, ARN14669Lowman Henry B Trustee · El Granada, CAN1466JLichman Robert P · Florence, SCN1467TThree2tango LLC · Mount Pleasant, SCN1468EMachado Donald C Jr · Honolulu, HIN1468THindle John Charles IV · Whitehouse Station, NJN1469TThree Wing Flight School LLC · Stratford, CTN146AAvila Edward V · Saint Johns, AZN146AMGospel Ministries International · Mc Donald, TNN146AVVidal Aviation LLC · Gaithersburg, MDN146CCRegistered aircraftN146CZNiewiarowicz Michael J · Golden, CON146DB4405 LLC · Jenks, OKN146DCAztec Worldwide Airlines Inc · Wilmington, DEN146DFMara Taylor D · Mckinney, TXN146FAcrehood Air LLC · St Augustine, FLN146JMarc Inc · Bolton, MSN146JPMartin John A · Grand Prairie, TXN146LWBelvedere Inc · Marion, IAN146MAHong Ted · San Jose, CAN146MBMlc Flying Club LLC · Saint Peters, MON146MWMehling Kevin E · WiesbadenN146NCHills Jason · Bothell, WAN146PWilliams Mike C · Sonora, TXN146PSAttitude Aerobatics LLC · Wilmington, DEN146RVLafford Richard M · Dansville, NYN146SCFantasy Aire Inc · Wilmington, DEN146SWFairway Systems LLC · New Port Richey, FLN146TCN146tc LLC · Minneapolis, MNN146UPatenaude Edward G Trustee · Rye, NHN146WHAmick Ralph O · Hatteras, NCN146XBrown Scott D · Bushnell, FLN14702Cartel Oil Records LLC · Kansas City, MON1470BBerger Leo · Nampa, IDN1470JKosik Richard R · Hughestown, PAN1470ZBig Tree LLC · Caldwell, IDN14714Poco Loco LLC · Mesa, AZN14718Slys Aircraft Service · Platte, SDN1472PFlight School Of Texas LLC · Wilmington, DEN1472TGreen Lakes Aviation LLC · Belton, SCN14734Thorman Bryan R · Grand Junction, CON14746Kashiwa Charles · Glens Falls, NYN14747Hausken Matthew · Centuria, WIN1474TStella Stephen G DBA · Fort Lauderdale, FLN14758Jim Franklin Aviation Service Inc · Ruidoso, NM
Back to AD 2006-10-21