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.
N8221YBill Kennedy Aviation LLC · Stuart, FLN82221Hahn Dave · Brooklyn Park, MNN82225Dow Clifford G II · Falmouth, MEN82226Plane & Pilot News · Ravenna, OHN8222DPaphos Airways LLC · Farmingdale, NYN8222FJefferson City Aviation Inc · Jefferson City, MON8222HBartek Matthew S · Wylie, TXN8222JShvetsov Vitaly S · La Canada Flintrid, CAN8222WMitzel Aaron · China Spring, TXN8222YMorale Line Aviation LLC · Albuquerque, NMN82236Ingle Nicholas A · Cora, WYN8223CCurless Timothy A · Demotte, INN8223NEvans Jay M · Arrington, TNN8223TTrident Aircraft Leasing LLC · Easton, MDN82241Naranjo Navarro Jose N · Las Vegas, NVN8224GSkylarkers Inc · Farmington, NMN8224KPelayes Tristan · Temecula, CAN8224NDc Aviation LLC · Appleton, WIN8224WDavis William M · Chattanooga, TNN8224YWoodard Earl G Jr · Danville, GAN82253Dirt Strip Dirtbags LLC · Whitefish, MTN82259Pedersen Eric D · Mccall, IDN8225AFast Track Aircraft LLC · Oxford, MSN8225CHastings Heidi R · Wasilla, AKN8225UNagy John F · Whittier, CAN8225VRunge Thomas A · Sterling, VAN8225WLewis Devin H · Lacey, NJN8225XWarren Dennis J · Denver City, TXN8225YInternational Air Services Inc Trustee · Carson City, NVFirst renewal noticeN8226CTyler Joseph Virgin · Wasilla, AKFirst renewal noticeN8226HForward Jeffrey C · Oakes, NDN8226VParchman Travis R · Philadelphia, PAN8226YC P L Air LLC · Middletown, DEN82274Harris James M · Bemidji, MNN8227GKritz Eric J · Gualala, CAN8227NRegistration Pending · Dawsonville, GARegistration pendingN8227WQuarter Circle E Enterprises Inc · Yorba Linda, CAN82285Horton Charles M · Wilkeson, WAN82286Registration Pending · Bullhead City, AZRegistration pendingN8228WKoaks Aviation LLC · Farmers Branch, TXN82293Egolf Mark A · Nine Mile Falls, WAN8229FSterling Aviation · Concord, CAN8229GEastman Gary Lynn · Penn Valley, CAN8229PMacair Aviation LLC · Xenia, OHN8229WRab Aviation Photography LLC · Lanexa, VAN822ABRice Allen J · Steinhatchee, FLN822ARCapen Ralph E · Laurel, DEN822BWAa-Aero Inc · Fairfield, NJN822CGRepublic Wings LLC · Moseley, VAN822DJCoscio David V · Kings Beach, CA
Back to AD 90-04-06 R1