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.
N494DWVieira Mark T · Turlock, CAN494FLWilliams Mark J · Ojai, CAN494HSale Reported · West Palm Beach, FLSale reported, pending cancellationN494JGGallagher Joseph Leo · Reno, NVN494LAPiper 3 LLC · Chestnut Ridge, NYN494RVBerthold Myles A · Belleville, ILN494TMDuke Flight Training LLC · Bonnyman, KYN494WAFly More Inc · Kawkawlin, MIN4950AShaffer Barbara J · Franklin, KYN4950DSimpson Darrell W · Soldotna, AKN4950LDesimone Joseph L · Castle Rock, CON49516Bresson Flying Service Inc · Compton, ILN4951A152 University LLC · Blacksburg, VAN4951BTaylor Randall G · Pottstown, PAFirst renewal noticeN4951GMelbourne Flight Training LLC · Melbourne, FLN4951HUS Flight Academy International Inc DBA · Post, TXN4951KSupp Charles M · Wells, NVN4951LMetcalf Linda G · Amarillo, TXN4951TVolaero Aviation LLC · Valdosta, GAN49527B&S Aviation LLC · Sylvania, OHN4952BC & T Aviation Holdings Inc · Mckinney, TXN4952GHighland Rim Aviation LLC · Springfield, TNN4952LWalters Larry C · Wasilla, AKN4952SPrecision Delta Corp · Ruleville, MSN4953BTfa Holding Corp · Daytona Beach, FLN4953FQuinney William B · Kill Devil Hills, NCN4953GMcfly LLC · Casper, WYN4953JLent Kevin C · Glenwood, MNN4953LSale Reported · Harrells, NCSale reportedN4953VMccreery Aviation Co Inc · Mcallen, TXN4954FGq Aviation LLC · Cherry Hill, NJN4954GKris Noone Air LLC · Wilmington, DEN4954HVega Jaime D · Garland, TXN4954LSavoie John P · Jal, NMN49551Wahl Dale H · Watertown, WIN4955DBerman David M · Charlotte, NCN4955LDakan John M · Hemet, CAN4955ZSmetana Arthur E · Elmwood Park, NJN4956DSorbi Aviation Inc · El Cajon, CAN4956VRegistered aircraftN49572Karnik Brandon S · Buffalo Lake, MNN4957APea-Wayman Flight LLC · Daytona Beach, FLN4957EKuckkahn Dale P · Lake Tomahawk, WIN4957LButler Cole A · Snowflake, AZN4958ALamonica Patrick H · San Diego, CAN4958FJuoni Joshua Charles · Oklahoma City, OKN4958JWinfrey Justin R · San Francisco, CAN4958LOgren James A · De Smet, SDN4958VFrank John M Jr · Alexandria, VAN4958ZDacy Roy Wayne · Kingsland, TX
Back to AD 90-04-06 R1