Skip to content

Registered aircraft · 4,242

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

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:89-24-01-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:89-24-01-R1') ORDER BY n_number

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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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.

N761RLCampbell Gordon S · Concord, CABuilt 1978 · S/N 21062457 N761SBBracl Holdings LLC · Tonganoxie, KSBuilt 1978 · S/N 21062471 N761SGThurmond Clark · Georgetown, TXBuilt 1978 · S/N 21062476 N761SHJs Flying Services LLC · Reno, NVBuilt 1978 · S/N 21062477 N761STBode Aviation Inc · Albuquerque, NMBuilt 1978 · S/N 21062487 N761TCMichigan Scientific Corp · Milford, MIBuilt 1978 · S/N 21062496 N761THBlack Forest Wings LLC · Noblesville, INBuilt 1978 · S/N 21062501 N761TKRichards And Richards · Nucla, COBuilt 1978 · S/N 21062503 N761TLOmni International Services Inc · Reno, NVBuilt 1978 · S/N 21062504 N761TMHwbec761 LLC · Los Ranchos, NMBuilt 1978 · S/N 21062505 N761TYAdw N761ty LLC · Chicago, ILBuilt 1978 · S/N 21062516 N761VWKennedy M John · Gillette, WYBuilt 1978 · S/N 21062562 N761WHPierson Tim E · Gooding, IDBuilt 1978 · S/N 21062573 N761WQTower Aircraft Associates Inc · Ventura, CAS/N 21062580 N761WTCv Aviation LLC · Logan, UTBuilt 1978 · S/N 21062583 N761XEGordon Bruce S Trustee · Aspen, COBuilt 1978 · S/N 21062594 N761XFRapa Dennis H · North Dartmouth, MAS/N 21062595 N761XGMedusa Inc · Lexington, VABuilt 1978 · S/N 21062596 N761XYAshby Scott J · Lemoore, CABuilt 1978 · S/N 21062612 N761XZKrabill Enterprises LLC · Christmas Valley, ORBuilt 1978 · S/N 21062613 N761YDAero Clean Technologies LLC · Lynchburg, VABuilt 1978 · S/N 21062617 N761YGGoody Birds LLC · Prattville, ALBuilt 1978 · S/N 21062620 N761YHArnett Family Inc · Mesa, AZS/N 21062621 N761YKFanning Fred W · Fairlawn, OHBuilt 1978 · S/N 21062623 N761YMSkyberry Jam Aviation LLC · Coppell, TXS/N 21062625 N761YSThompson Gary P · Mammoth Lakes, CABuilt 1978 · S/N 21062630 N761YWWalker Gilbert C · Camerillo, CABuilt 1978 · S/N 21062634 N761ZBIts Academic Inc · Elyria, OHBuilt 1978 · S/N 21062639 N761ZEBrandvik Pipe & Equipment Inc · Borger, TXS/N 21062642 N7632QPremier Helicopters LLC · Carson City, NVBuilt 1973 · S/N 340-0236 N763EAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0497 N764EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0237 N764PBBisono Pablo R · Guaynabo, PRS/N 402C0338 N764SAerotrans Management LLC · Mercer Island, WABuilt 1979 · S/N U20604957 N765FLAviation Angel Tours LLC · Beverly Hills, CABuilt 1975 · S/N 414-0644 N765JBN765jb LLC · Colorado Springs, COS/N 340A0647 N765LTDrj Aviation LLC · Dover, DES/N 340-0181 N766DBWhelan And Associates Pllc · Eagle, COBuilt 1980 · S/N EA-98 N76747Walter Timothy Andrew · San Rafael, CABuilt 1979 · S/N EA-41 N767RRRed Leasing LLC · Juneau, AKBuilt 1972 · S/N 310Q0455 N769ACAircraft Propulsion Leasing LLC · Holland, OHBuilt 1978 · S/N TK-89 N769EAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0303 N76BLBravo Lima Corp · Lakewood, COBuilt 1973 · S/N 21059808 N76CWYatahey LLC · Middletown, DEBuilt 1976 · S/N 310R0695 N76KTWarriors With Wings LLC · Zebulon, NCBuilt 1974 · S/N 414-0508 N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204 N7702QRobinson Meyer · Daphne, ALBuilt 1970 · S/N 310Q0202 N770CFKopp Adrian D · Brookville, INBuilt 1978 · S/N U20604569 N7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeS/N P21000072 N7719QTurel Stanley · Bend, ORBuilt 1973 · S/N 3400194

Back to AD 89-24-01 R1