AD 2000-01-16
Registered aircraft · 2,711
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:2000-01-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-01-16')
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:2000-01-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-01-16') 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.
N1596TPlane Crazy Inc · Page, NDN15DSAll Attitude Aviation Inc · Edgewater, FLN15SVGore Joshua · Sedro Woolley, WAN15VVLiberty Flying Club Inc Trustee · Wilmington, DEN15WMSidhu Teg Singh · Bakersfield, CAN15ZPStefenelli Aviation N Tr Inc Trustee · AtterseeN1600TBpm Rentals Inc · Lincoln, CAN1603TMedcare Emergency Medical Services Inc · Mcallen, TXN160DCPdii LLC · Concord, NCN160PBHyannis Air Service Inc · Hyannis, MAN1616TDavila Alexander · Davie, FLN1618TRandolph James · Greensburg, PAN161RMTurbine Screws LLC · Bozeman, MTN1621TBeats Driving Inc · Northbrook, ILN1624TMelnik Charles J DBA · Omaha, NEN1627TSierra Leasing LLC · Sheffield, ALN1637TSmith Taylor · Amarillo, TXN1646TOrellana Willson Daniel · Hesperia, CAN1652TBas Part Sales LLC · Greeley, CON165SASouth Aero Inc · Albuquerque, NMN1668TKevu Aviators LLC · Maryville, MON1670THyde Family Aviation LLC · Wilmington, DEN1678TGabaldon Martin · El Paso, TXN167AWPlane Fun Inc Tr Trustee · Snellville, GAN167WAGrid Aero Inc · San Leandro, CAN168GGWisconsin Aviation Inc · Watertown, WIN168WACharles Michel · St Thomas, VIN169KSSvetfur Aviation LLC · Camden, SCN16ASStefenelli Aviation N Tr Inc Trustee · AtterseeN16EZAmerican Aerial Survey Inc · Rancho Murieta, CAN16QCDawson Aircraft Inc · Clinton, ARN1716EMccaskill William L · Hampton, VAN171JSSerrato Joel · Brownsville, TXN1742ECole-Tac LLC · Rapid City, SDN174DSSky West Aviation Inc Trustee · Albuquerque, NMN175AMStevens Daniel · Oak Creek, CON175KBTvpx Ars Inc Trustee · North Salt Lake, UTN175SPN500aa LLC · Wilmington, DEN176MMRair Air Inc · Stateline, NVN1781ECallaham John · Broken Bow, OKN17AMFarmdog Aviation LLC · Lafayette, INN17HLRiley Charles S · Littleton, CON17MHEcho Aviation LLC · Verona, WIN17NWEye Clinic Building Lllp · Bismarck, NDN1821EHth Companies Inc · Union, MON1842SFry William A · Willmar, MNN184XTitan Island Aviation LLC · Houston, TXN1856EGv Air Inc · Medford, ORN1879ERaw Racing Inc · Puyallup, WAN188GWBrown Die Casting & Manufacturing Inc · Royse City, TX
Back to AD 2000-01-16