Skip to content

Registered aircraft · 17,028

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N78190Prp Aviation LLC · Ocala, FLBuilt 1968 · S/N 17257520 N78195Mishawaka Pilots Club Inc · Osceola, INBuilt 1968 · S/N 17257522 N78197Allen County Regional Airport Authority · Lima, OHBuilt 1968 · S/N 17257523 N7819GCre Aviation Holdings LLC · Ramona, CABuilt 1970 · S/N 17259519 N78207Sherman Todd P · Collinsville, OKBuilt 1968 · S/N 17257526 N78215Alvarado Eduardo · Fayetteville, TXBuilt 1968 · S/N 17257530 N78219Testa Christopher · Kennesaw, GAFirst renewal noticeBuilt 1968 · S/N 17257532 N7821FKoch Leasing LLC · Campbellsville, KYBuilt 1966 · S/N 15063921 N78221Waldrop Floyd D · Robinson, ILBuilt 1968 · S/N 17257534 N78228Lanning Keith L · Everton, ARBuilt 1968 · S/N 17257537 N78239Draco Flight School DBA · Chino, CABuilt 1968 · S/N 17257540 N7823FJackson Larry T · Maplesville, ALS/N 15063923 N7823GAmerican Patrols Inc · Midland, TXBuilt 1970 · S/N 17259523 N78240Kinney Joan M · Vermillion, SDBuilt 1968 · S/N 17257541 N78242176fps LLC · Marthasville, MOBuilt 1968 · S/N 17257543 N78249Howard Ronald W · Okeechobee, FLBuilt 1968 · S/N 17257545 N78253Chatman Hannah K · Poplar Bluff, MOS/N 17257546 N78254Bpk Holdings LLC · Montesano, WABuilt 1968 · S/N 17257547 N7825UVan Dyke Randall R · Spencer, IABuilt 1964 · S/N 17251825 N7826681 Escadrille Inc · Hutchinson, KSBuilt 1968 · S/N 17257549 N7826UDenton Aeroworx LLC · Tucson, AZBuilt 1964 · S/N 17251826 N7827GFlying Falkor LLC · Bellevue, WAS/N 15074732 N7827UCook Loretta · Bel Air, MDBuilt 1964 · S/N 17251827 N78286Marsh David J · Sioux Falls, SDBuilt 1968 · S/N 17257554 N7828FTaylor Andrew G · Lexington, KYBuilt 1966 · S/N 15063928 N7828UDroz Chris G · Jamul, CAS/N 17251828 N78295Cofsky Gregory J · Sandwich, MABuilt 1968 · S/N 17257556 N78299Jb Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 17257558 N7829GKilo Sierra Aviation LLC · Sammamish, WAS/N 17259529 N78302Gardner Christopher · South Saint Paul, MNBuilt 1968 · S/N 17257559 N78303Citizen Air LLC · Port Angeles, WABuilt 1968 · S/N 17257560 N78305Woollen Claude D · Moore, SCBuilt 1968 · S/N 17257562 N7830GSkildum&Company LLC · Grand Marais, MNBuilt 1970 · S/N 17259530 N7830UObrien Cornelius R · Sellersville, PABuilt 1964 · S/N 17251830 N78312Roemer Joanne · Kemah, TXS/N 17257565 N7831FHallmark Ryan M · Vidor, TXBuilt 1966 · S/N 15063931 N7831UHerrin Thomas · Patterson, GABuilt 1964 · S/N 17251831 N7832UFly 32u LLC · Monroe, NCBuilt 1964 · S/N 17251832 N78330Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257567 N78331Clifton Jack D · La Junta, COS/N 17257568 N78332Albright John T · Decatur, ALBuilt 1968 · S/N 17257569 N78335Marotte David J · Windham, NHBuilt 1968 · S/N 17257570 N78338Mbh Aviation LLC · Tulalip, WABuilt 1968 · S/N 17257572 N78339Hopfmann Alwin E · Rutland, MABuilt 1968 · S/N 17257573 N7833GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259533 N7833ULfs Inc · Gillette, WYBuilt 1964 · S/N 17251833 N78341Davis Glenn A · Fair Oaks, CABuilt 1968 · S/N 17257575 N78349Raker Theodore B · Hahira, GABuilt 1968 · S/N 17257578 N7834GSmith Perry L · Brook Park, MNS/N 17259534 N7834USirens Call LLC · Nashville, TNBuilt 1964 · S/N 17251834

Back to AD 72-03-03 R3