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.
N8214YRegistration Pending · Harrisburg, SDRegistration pendingN82155Maroney Thomas L · Wasilla, AKN8215GGersten Iron · Spring Valley, CAN8215NRyder Paul M · Charlotte, NCN8215YGlassburn Teresa L · Winthrop, WAN82165Piper Aircraft Inc · Vero Beach, FLN82166Minuteman Aviation Inc · Missoula, MTN82168Earth Center Adventures Inc · Haines, AKN82169Patterson Colin G · Ballston Spa, NYN8216CYoung Mikaela R · Fairbanks, AKN8216GFarrar Edwin L · Mansfield, OHN8216NShelton William B · Wildwood, MON8216PBobbitt Aviation LLC · Edenton, NCN8216SNulton Enterprises LLC · Johnstown, PAN8216WBritair Inc · Austin, TXN8216YMedia Stew LLC · Carson City, NVN82172Wadekamper Leo V · Helena, MTN8217NG U M P S Flying Club Inc · Warner Robins, GAN8217QParis Air Inc · Vero Beach, FLN8217SValles Robert Jr · Spicewood, TXN8217YMaledy John Trustee · Salem, MON8218Kornegay Patrick C · San Benito, TXN82188Kubecka Daniel P · Edna, TXN8218CStargazer Aviation LLC · Clearwater, FLN8218NLee David · Palm Springs, CAN8218ZWingsleasing LLC · Wichita, KSN82190Salav LLC · Salisbury, NCN82196Flying W Ranch Jv · Cooperstown, NDN8219GSchaum Jerome B · Machipongo, VAN8219WA18 Missions LLC · Clinton, MON8219YDurden Julian F Jr · Twin City, GAN821BABarr Air Patrol LLC · Mesquite, TXN821BERas Aviation LLC · Elyria, OHN821BFDehn Timothy E · Braham, MNN821BPPerdue Joseph D · Marshall, OKN821ESSchmitz Mark J · Ames, IAN821FJ8th Dimension Enterprises LLC · Aurora, ORN821GMHoosier Aviation LLC · Terre Haute, INN821KCIreland Robert D Jr · Gulf Breeze, FLN821LLindrooth Steven A · Perkasie, PAN821PASkywest Leasing Inc · St George, UTN821PCJones Clark L · Cave Creek, AZN821PTHermes Ana Paula F · West End, NCFirst renewal noticeN821RPVan Cleave Raymond D · Kalispell, MTN821SDGlobal Adventures N821sd LLC · Hollywood, FLN821SHAero Leasing Inc · Brookings, ORN82209Pearl Darwyn L · Bend, ORN82213Anderson Stephen A · Yuba City, CAN8221GIshoy Glen · Indiana, PAN8221NFedchenko Vitaliy · Cumming, GA
Back to AD 90-04-06 R1