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.
N1952CButler William J II · Juntura, ORN1952TLeardo Inc · Plano, TXN1952YVess Derek Wayne · Kempner, TXN1952ZButler William J II · Juntura, ORN1953HBritton Scott M · Fairview, TXN1953LWyatt Shawn D · Fort Worth, TXN1953RSmith Helicopters Inc · Cotulla, TXN1953TDaniella Levi & Associates Pc · Fresh Meadows, NYN1953YDavid Michael B · Miami Beach, FLN1954SBarca Sky F · Simi Valley, CAN1954TDmac Aircraft LLC · Savannah, GAN1954YSasse David L · Rio Rancho, NMN1955YBeckworth Willis S · Gonzales, LAN1956LMeisinger Darrell G · Claremore, OKN1956SRegistered aircraftN1956VMedary Aviation LLC · Brookings, SDN19575Galis Iuri · Oklahoma City, OKN1957LSmith Joseph M · Ames, IAN1957TPipers Are Still Better LLC · Carson City, NVN1957YGuedon Aviation LLC · Natchez, MSN1958LTalamini Paul J · Franklin, MAN1959HN1959h Aviation LLC · Hillsborough, NJN1959YJam Aviation LLC · Wallace, MIN195AJ195aj LLC · Toledo, OHN195DWJohnson Richard G Jr · Fredericksburg, TXN195FAPinkston Pat · Carrollton, ILN195GMStickell Rutherford D · Frederick, MDN195JGN195jg Aviation LLC · Port Republic, NJN195JRQualitair LLC Trustee · MichelstadtN195MASkywest Leasing Inc · St George, UTN195NWNorthwestern Michigan College · Traverse City, MIN195PBCma Group LLC · Chattanooga, TNN195PJSwif LLC · Atlantic, IAN195RBHess Gary Alan · Petoskey, MIN195RFFeehery George R Jr · West Newbury, MAN195TCPentz Larry Dean · Duvall, WAN195TJJennings Christopher D · Tracy, CAN195WVRainbow Sports Inc · Enid, OKN1960Jackson Chester L · Sherman, TXN1960LButler David · Palos Park, ILN1960TRay Steven B · Fort Collins, CON1960YWhite Duwayne F · Hermiston, ORN1961JCullen Stephen · Washington, INN1961YWarnock Tony J · Mobile, ALN1962LDelacantera Eduardo · New Castle, DEN1962PStone Philip R · East Syracuse, NYN1962TPinnacle Plane Company LLC · Aberdeen, NCN1962YRuther Jimmie M · Vacaville, CAN1963JTeam Robinson Holdings LLC · Denver, NCN1963SSurgent Richard L · Wall Township, NJ
Back to AD 2006-10-21