AD 90-02-13
Registered aircraft · 3,863
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:90-02-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-02-13')
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:90-02-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-02-13') 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.
N1668TKevu Aviators LLC · Maryville, MON166AMColvin Clu D DBA · Big Cabin, OKN1670THyde Family Aviation LLC · Wilmington, DEN1678TGabaldon Martin · El Paso, TXN167AWPlane Fun Inc Tr Trustee · Snellville, GAN167WAGrid Aero Inc · San Leandro, CAN168EDTsg Aviation LLC · Wyandotte, MIN168GGWisconsin Aviation Inc · Watertown, WIN168WACharles Michel · St Thomas, VIN169DKStanton James · North Barrington, ILN169KSSvetfur Aviation LLC · Camden, SCN16ASStefenelli Aviation N Tr Inc Trustee · AtterseeN16QCDawson Aircraft Inc · Clinton, ARN16SGWard James · Arroyo Grande, CAN1710HQuon Nicholas · Fayetteville, GAN1712HColvin Clu D DBA · Big Cabin, OKN1718ECaptain Kenny J LLC · Holiday, FLN1718HSale Reported · Bartlesville, OKSale reported, pending cancellationN171JSSerrato Joel · Brownsville, TXN1722HWashington State Community College · Spokane, WAN1731HDonadio Robert F · Amherst, NHN1735ERsc Ventures LLC · Phoenix, AZN1737EKeystone Aerial Surveys Inc · Philadelphia, PAN174DSSky West Aviation Inc Trustee · Albuquerque, NMN174KBlueskies Aviation Services LLC · Charlestown, INN175AMStevens Daniel · Oak Creek, CON175KBTvpx Ars Inc Trustee · North Salt Lake, UTN175SPN500aa LLC · Wilmington, DEN1760HReeve Howard E · Minot, NDN1766HOrlandi Properties LLC · Blairstown, NJN1768ERoyal Air Freight Inc · Waterford, MIN1777HFait Coleman B · Newport Beach, CAN1783HRegistration Pending · Anchor Point, AKRegistration pendingN1784EHigh Road Time LLC · West Palm Beach, FLN1791ESol Aerial Surveys LLC · Las Vegas, NVN1795ERb Aviation LLC · Tyler, TXN1796GHorowitch Alan · San Diego, CAN1797HRons Air Service Inc · Two Buttes, COFirst renewal noticeN17AMFarmdog Aviation LLC · Lafayette, INN17GWSalus Aviation LLC · Jupiter, FLN17HLRiley Charles S · Littleton, CON17MHEcho Aviation LLC · Verona, WIN17NWEye Clinic Building Lllp · Bismarck, NDN17UAce Flight LLC · Houma, LAN1811HLeggett Jason · Bogue Chitto, MSN1816HKiever Robert P · Summerland Key, FLN1827HWard Austin · Kokomo, INN1831HKulp Clayton H · Wichita, KSN1837HYeagley Daun III · Moraine, OHN1842SFry William A · Willmar, MN
Back to AD 90-02-13