AD 90-04-06 R1
Registered aircraft · 68,377
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-04-06-R1')
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-04-06-R1')
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-04-06-R1') 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-04-06-R1') 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.
N918FAWestways Aviation LLC · El Cajon, CAN918GArcher Flight LLC · Wilmington, DEN918HYBumble Bee Air Inc · Menlo Park, CAN918JBBriggs Michael N · Mableton, GAN918MBLive More LLC · Fort Worth, TXN918MLCluff Omatthew M · Payson, AZN918PMMathews Roy · Bay Shore, NYN918RAAldridge Aviation LLC · Hiwasse, ARN918RVDuggan Michael M · La Verne, CAN918SNorton Wesley R · Medford, ORN918TFRegistration Pending · Portland, ORRegistration pendingN918UGriffith Aviation Inc · Griffith, INN918VPVanderpool Robert W · Red Devil, AKN918WGKisieleski Timothy J · Amesbury, MAN918YInternational Air Services Inc Trustee · Carson City, NVN91906Martin Jonathan B · Alamogordo, NMN91908Hollingsworth Lloyd Dan · Anchorage, AKN9190JLarchar William S · Rockledge, FLN91911Messinger Donald E · Wasilla, AKN9191JArmstrong Donald Bradford · Sterling, CON9191LMeyer Gordon L · Knoxville, TNN9191N9191n LLC · Salem, NHN91925Rl Aviation LLC · Miami, FLN9192DHadley Sheldon L · Hope, ARN9192VPlane Fun Inc Tr Trustee · Snellville, GAN9193GMach One Velocity LLC · Macomb Twp, MIN9193HPrairie Flyers Flying Club · Eudora, KSN9193JGref Michael C · Murfreesboro, TNN9193LAdriatic Holdings LLC · Cheyenne, WYN9193SMiller Brian P · Middletown, INN9194DDaniels Daryl A · Warren, OHN9194JStange Robert C · Toledo, OHN9194KHarry Philip · Asheville, NCN9194LRussell Keith M · Ivoryton, CTN9194VAlva Aviation LLC · Nacogdoches, TXN9195JLau-Camarena Alvaro · Euless, TXN9195KWatson Joseph L Jr · Concord, NCN9195LStatewide Transportation LLC · Oklahoma City, OKN9195SBailey Thomas P · Cannelton, INN9195VHunter Robert J DBA · Montgomery, ALN9196HLaplante Rene J · Bellingham, WAN9196JScarlett Seth T · Omaha, NEN9196LRunyon Larry · Susanville, CAN9196SSkyward Leasing Inc · Dallas, GAN9196VScherbarth Kenneth C · Eatonville, WAN9197BEsteban John G · Dublin, NHN9197JDifabio Jack F · Newtown, PAN9197LSchutze Curt K · Knoxville, TNN9197SEisenhaur Timothy · Wells, MEN91984A-Line LLC · Kent, WA
Back to AD 90-04-06 R1