Skip to content

Registered aircraft · 17,027

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.

N1DZXtreme Flying Services LLC · Gansevoort, NYBuilt 1961 · S/N 18253742 N1GXOclair Carleton Brent · Saco, MEBuilt 1973 · S/N 17702009 N1KBThibault Ryan D · Anchorage, AKBuilt 1967 · S/N 15067470 N1LQStrydom Cornelis F · Liberal, KSBuilt 1966 · S/N T210-0148 N1NSEagle Equity Inc · Valparaiso, INBuilt 1973 · S/N 15074284 N1TAJustine Lorraine F · Newark, DEBuilt 1972 · S/N 17260453 N1TLLewis Thomas A · Roanoke, VABuilt 1974 · S/N 15075710 N1XSaitto Jeffrey M · Media, PABuilt 1965 · S/N 17252958 N1YDBerg Bradley · Tulare, CABuilt 1968 · S/N 21059105 N20008Crabdree Marty D · Conroe, TXBuilt 1977 · S/N 17702621 N2001QMutschler Thomas A · Belle Vernon, PABuilt 1973 · S/N 177RG0401 N2001RAllen Aeronautics LLC · Mocksville, NCS/N 18255201 N20023Usnick Robert W · Mc Donald, PABuilt 1977 · S/N 17702622 N2002QPrecision Aero LLC · Wilmington, DEBuilt 1973 · S/N 177RG0402 N2002RWentzel Jason A · Dupont, WABuilt 1963 · S/N 18255202 N2003Q177rg LLC · Dover, DEBuilt 1973 · S/N 177RG0403 N2003RPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1963 · S/N 18255203 N2004RMorasch Robert G · Walla Walla, WABuilt 1963 · S/N 18255204 N2004XCovetous Inc · Fallbrook, CAS/N 18256104 N20056Haney Randall M · Boaz, ALBuilt 1977 · S/N 17702624 N2005QCoon Roger E · Springtown, TXFirst renewal noticeBuilt 1973 · S/N 177RG0405 N2005XTurnmire Jeffry B · Knoxville, TNBuilt 1965 · S/N 18256105 N2006QFarr Brad L · Uvalde, TXBuilt 1973 · S/N 177RG0406 N2006RBarclay Mechanical Services Of Utah Inc · Manti, UTBuilt 1963 · S/N 18255206 N2007QHopkins William · Reno, NVS/N 177RG0407 N2007RDoc'S Flying Club LLC · Macon, GABuilt 1963 · S/N 18255207 N2007TWinger Raymond E · Johnson, KSS/N 18258171 N20085Fleming Ian · Peoria, AZBuilt 1977 · S/N 17702626 N2008QCoulter Dennis · Lincoln, CABuilt 1943 · S/N 177RG0408 N20094Valiair Lc Trustee · Casper, WYS/N 17702627 N2009QTranby Wayne A · Fargo, NDBuilt 1973 · S/N 177RG0409 N200PSMerren R Todd DBA · Montgomery, ALBuilt 1967 · S/N 67-15030 N200RXAndrews Laral B · Portland, ORS/N 15067073 N200SDKing Dwayne W · Sutton, AKBuilt 1969 · S/N 15070651 N200TLHusnik Brad M · Forest Lake, MNBuilt 1966 · S/N U206-0559 N200ZKInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 17255678 N2010QShadow Blade Technologies LLC · Palm Bay, FLBuilt 1973 · S/N 177RG0410 N2010XHutchinson Darrold K Trustee · Hingham, MTBuilt 1965 · S/N 18256110 N20116Paxton Roger D · Norman, NCFirst renewal noticeS/N 17702630 N2011QManzo Mario A · Sacramento, CAS/N 177RG0411 N2011XSalem Ricky L · Burnet, TXBuilt 1965 · S/N 18256111 N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631 N20127Lewallen David H · Alexander, ARBuilt 1977 · S/N 17702633 N2012QOwens Joseph L · Fort Mohave, AZBuilt 1973 · S/N 177RG0412 N2012RPhysical Therapy And Sports Solutions LLC · Santa Fe, NMBuilt 1964 · S/N 18255212 N2013RZinsmeyer Charles D · Llano, TXBuilt 1964 · S/N 18255213 N2013XEec Group LLC · Kalispell, MTBuilt 1965 · S/N 18256113 N20142Johnson Lindley N · Kingstowne, VAS/N 17702635 N20145Avco Patrol LLC · Lyndon, KSS/N 17702636 N2014QRegistration Pending · Glennville, GARegistration pendingBuilt 1973 · S/N 177RG0414

Back to AD 72-03-03 R3