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.
N7190BKing Tyler Brooks · Saint Stephen, SCN7190CJets To Helis LLC DBA · Chandler, AZN7190DWard Ben N · Salcha, AKN7190GM T Machinery Inc · Porter, TXN7190JEmerald City Aircraft Leasing Inc · Port Orchard, WAN7190LYoung Anthony G · Murray, KYN7190QEhc Group LLC · Franklin Lakes, NJN7190RChristopher Ralph K · Weedsport, NYN7190WAndros Aviation LLC · Santa Margarita, CAN7190YMiller Kevin · Collegedale, TNN7191DDahlen Bear A · Eugene, ORN7191EStandard Aviation Services LLC · Farfurrias, TXN7191PRamineni Raja · Fort Mill, SCN7191UDarrow Matthew J · Truckee, CAN71921Rychlik Kevin Charles · Manassas, VAN7192LCheek Donald · Ocala, FLN7192QMansfield Heliflight Inc · Milton, VTN7192SUniversal Technical Institute Inc · Phoenix, AZN7192WPope Larry · Lake View, NYN7193DKeech Paul A · Fairbanks, AKN7193LLevison Louis · Klamath Falls, ORN7193UJets To Helis LLC DBA · Chandler, AZN7193VArmbruster Jeffrey T · Norfolk, NEN7194Ajayi Samuel O · Fredericksburg, VAN7194BBooker Louis E Jr · Pinetop, AZN7194CCivil Air Support LLC · Phoenix, AZN7194DBeacon West LLC · Billings, MTN7194GAvco Patrol LLC · Lyndon, KSN7194KHolt Tommy · Big Lake, TXN7194QOzarks Auto Show Inc · Hollister, MON7194RAltair Associates · Middletown, DEN7194WWagner Jeffrey P · Bridport, VTN7195EMn Helicopters Inc · Blaine, MNN7195GBurnside George C II · Hattiesburg, MSN7195QPuget Sound Flyers · Everett, WAN7195VScherer Eric · Mooresville, NCN7195WMueller Reinhard B · Sparta, WIN7195ZDenis Ranch · Vancourt, TXN7196LDodson International Parts Inc · Rantoul, KSN7196QBurdis W J · Beaver Falls, PAN7196RCrisler Capital LLC · Sunnyvale, TXN7196WJets To Helis LLC DBA · Chandler, AZN7196YAircraft & Aviation Professionals LLC · Coldwater, MIN7197GFly Wissota LLC · Chippewa Falls, WIN7197LMorris Gary M · Lucedale, MSN7197RTaylor Timothy T · Quitman, ARN7197ZAero Tech Academy Inc · Redlands, CANon-citizen corporation, flight hours not reportedN7198AFlying J Services LLC · Jourdanton, TXN7198GJones Lawrence A · St Simons Island, GAN7198JEmerald City Aircraft Leasing Inc · Port Orchard, WA
Back to AD 90-04-06 R1