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.
N757HERussell Robert Q · Genoa City, WIN757HHA&R Aero LLC · Sacramento, CAN757HMSchmitt Rudy · Brookshire, TXN757HTParrish Aviation Flight Academy LLC · Southlake, TXN757HVPropel Air LLC · Pottstown, PAN757HXAppalachian Aviation LLC · Harrisonburg, VAN757HYWings Over Texas Holdings LLC · Denton, TXN757JBBrilhart John G · Higbee, MON757JDSuburban Air Corp · Castro Valley, CAN757JGJet & Rotor Aviation LLC · Sacramento, CAN757JJJetstream Aeronautics LLC · San Antonio, TXN757JKMcdermotts Letsfly LLC · Somerton, AZN757JXHillsboro Aero Academy LLC · Hillsboro, ORN757JYBreuer Lisa M · Horseshoe Bend, IDN757KFBob Hoover Academy · Salinas, CAN757KMClover Park Technical College · Tacoma, WAN757KPPhill-Air Inc · Dover, DEN757KXDamian Davis Construction Co · Candler, NCN757LKloss Todd T · San Antonio, TXN757LBSwaney Brian W · Pendleton, SCN757LELake Elmo Aero LLC · Lake Elmo, MNN757LGMamet Oren · Andover, MAN757LHWoldow Frederic A · Morton, ILN757LMYeary Clifton K · Quitaque, TXN757LNWings Over Texas Holdings LLC · Denton, TXN757LPPrice Thomas E · Ogden, UTFirst renewal noticeN757LXSt Louis Flight Training LLC · Cahokia, ILN757LYHillsboro Aero Academy LLC · Hillsboro, ORN757MGOhio Gypsum Floors LLC · Westerville, OHN757MK101 Flight LLC · Waterford, MIN757MLSchaffer Michael W · New Meadows, IDN757MMDsr-Cherokee 180 LLC · Dallas, TXN757MPAvcorp Holdings Inc · Jackson, MIN757MSAngel Aviation Inc · Peoria, AZN757MYStaley Grady R · Liberty, NCN757NGWeisman Craig A · Falls Of Rough, KYN757NJSpace Coast Aircraft Co · Merritt Island, FLN757NNCarton David M · Claremont, NHN757NQA&R Aero LLC · Sacramento, CAN757PMKaiser Gavin · Peachtree City, GAN757PPFields Joseph H · Placerville, CAN757PTPavlock Russell H · Tinley Park, ILN757QBHutchison William B · Canton, OKN757QHWings Over Texas Holdings LLC · Denton, TXN757QJWaters Thomas J · Hampton, GAN757QQKostelecky Scott J · Decatur, TXN757RLRudak Phillip Richard · Wethersfield, CTN757RNSky Aviation & Maintenance Inc · Wildomar, CAN757RPBoyne Valley Flyers Club Inc · Boyne Falls, MIN757RTEnright Darren R · Lakeville, MN
Back to AD 90-04-06 R1