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.
N781SWScott Robert E · Sarasota, FLN781YToole William Barry · Goochland, VAN78207Sherman Todd P · Collinsville, OKN7820CSummit Flight Academy LLC · Peculiar, MON7820NPisas Flyers Inc · East Alton, ILN7820VHarris Colby L · Yellville, ARN7820WJamah Hani · Boonville, CAN7820YComa Pipe LLC · Wilmington, DEN78215Alvarado Eduardo · Fayetteville, TXN78219Testa Christopher · Kennesaw, GAFirst renewal noticeN7821CArmy Knife Enterprises LLC · Oak Hills, CAN7821NStradtner Adam · Laporte, INN78221Waldrop Floyd D · Robinson, ILN78228Lanning Keith L · Everton, ARN7822DTwinco Leasing LLC · Yacolt, WAN7822VBarry John J · Bethel, CTN78238Weaver William B · Vancouver, WAN78239Draco Flight School DBA · Chino, CAN7823BBombardo Joseph V · Clermont, FLN7823DBurnopp Jacob A · Evington, VAN7823GAmerican Patrols Inc · Midland, TXN7823HCharley Arrie · Gakona, AKN7823NKaiten Aviation LLC · North Haven, CTN7823VNelson Brent E · Richland, WAN7823WCdm Dirt LLC · Snowflake, AZN78240Kinney Joan M · Vermillion, SDN78242176fps LLC · Marthasville, MON78249Howard Ronald W · Okeechobee, FLN7824CRegistered aircraftN7824DWhitaker Samuel M · Brooklet, GAN7824NMcatarian Mark F · Saint Marys, KSN7824VLyon Timothy P · Kansas City, MON7824WHornbill Aviation LLC · Incline Village, NVN78253Chatman Hannah K · Poplar Bluff, MON78254Bpk Holdings LLC · Montesano, WAN7825LKlause Stephen E · Covina, CAN7825ND&D Vision Air LLC · Aubrey, TXN7825VHenderson Randy G · Williamstown, WVN7825WNelson Aaron D · Carver, MNN7826681 Escadrille Inc · Hutchinson, KSN7826VUse Your Call Sign Holdings LLC · Kalispell, MTN7826YInternational Air Services Inc Trustee · Carson City, NVN7827CKestrel Aviation LLC · Reno, NVN7827DThree Legged Hog Aviation LLC · Boise, IDN7827NBest John P · Goldsboro, NCN7827VJaffe Michael R · Terrell, TXN7827WWoods Perry H · Brownsville, TXN7827YEpton Richard Charles · Senoia, GAN7828Lionel Long · Liberty, KYN78286Marsh David J · Sioux Falls, SD
Back to AD 90-04-06 R1