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.
N64942Hillsboro Aero Academy LLC · Hillsboro, ORN64943Tipton Donald Jeffrey Sr · Maryville, TNN64944Dsr-Cherokee 180 LLC · Dallas, TXN64949Heavy Metal Air LLC · Farmingdale, NYN6494JKennedy Quincy A IV · Florence, SCN6494RTurner Manley W Jr · Fredericksburg, VAN6495JStp Flight LLC · Saint Paul, MNN6495QBaker Chad W · Forney, TXN6495UOtto David L · Lacey, WAN6495WScheibinger Alois E · Oshkosh, WIN64962Wingsleasing LLC · Wichita, KSN64964Dodson International Parts Inc · Rantoul, KSN64966Hill Mark T · Gloucester, VAN6496JBudke Kris J · Osceola, WIN6496LTurn Key Aviation LLC · North Las Vegas, NVN6496UWeaver Jimmie G · Winston Salem, NCN64971R&R Aero Services LLC · Eden Prairie, MNN6497AHenry Mark Alan · Dickinson, TXN6497UPointer James E · Cumming, GAN64980Miller James · Gulfport, MSN64985Keenan Jim · Neenah, WIN64987Stanford Jay J · St Marys, GAN64989Verderame Robert A · Metairie, LAN6498FWisener Randall G · Addison, ALN6498JKvistad Jerome L · Coon Rapids, MNN6498QShartle Wesley P · Fredericksburg, PAN6499QWhiteside Kim D · Decatur, ILN6499RGoodroe Zachary A · Santa Rosa Beach, FLN6499USolley Richard T · Mott, NDN6499WMarston Benjamin E · Seale, ALN649ESFlymore Aviation LLC · Philadelphia, PAN649FTFlorida Institute Of Technology · Melbourne, FLN649GCAviation Paradise LLC · Homestead, FLN649MBThompson Brian P · Lebanon, TNN649NDUniversity Of North Dakota · Grand Forks, NDN649RVWasatch Mooniacs LLC · Draper, UTN649SAHelm Craig Anthony · Graham, TXN649TGGrove Todd M · Lake Stevens, WAN64ACRm Thomas Co Inc · Lewes, DEN64AKKenley Fredrick · Palmer, AKN64AMSkahen Sean M · Saint Joseph, MNN64CASwaz Aviation LLC · Mesa, AZN64CWHolmsley Peery · Sheffield, TXN64DEHardin Donald D · Kirkwood, MON64DJBruzos Emiliano M · Houston, TXN64DKLevy Michael T · El Prado, NMN64DROlson Russell O · Eureka Springs, ARN64DTSharp Travis · Anchorage, AKN64EFHampton Flying Services LLC · Portsmouth, NHN64ELPridemore Michael R · Newport, MI
Back to AD 90-04-06 R1