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.

N3698UJk Fly LLC · Abie, NEBuilt 1963 · S/N 18255098 N3699JBlock Time Bandits LLC · Boise, IDBuilt 1966 · S/N 15064999 N369KSkydive Inc · Eagle Creek, ORBuilt 1963 · S/N 18254634 N369RAShaffer Patricia G · Texarkana, TXBuilt 1971 · S/N 17259719 N36DSUp And Up Aviation LLC · Spring, TXBuilt 1970 · S/N 17259145 N36RCAiken Air Sales And Rentals LLC · Aiken, SCBuilt 1970 · S/N 18260311 N36TDThayer Kenneth R · Bonita Springs, FLBuilt 1971 · S/N 15073090 N3700JOluoch Bill Rachuonyo · San Francisco, CABuilt 1966 · S/N 15065000 N3700URydberg Lawrence · Albuquerque, NMBuilt 1963 · S/N 18255100 N3701LRice Solutions LLC · Plymouth, NHS/N 17253870 N3701UBowley Steven Jon · Phoenix, AZS/N 18255101 N3702JMaslovsky Serhiy A · Carbondale, ILBuilt 1966 · S/N 15065002 N3702LBailey April O · Papillion, NEFirst renewal noticeS/N 17253871 N3702UCc Flyers LLC · Corpus Christi, TXS/N 18255102 N3703JSilver And Associates LLC · Ojai, CAS/N 15065003 N3704FBrzezinski Samuel M · Boyceville, WIS/N 17255199 N3704LN3704l LLC · Jacksonville, FLBuilt 1965 · S/N 17253873 N3705LRed Five Aviation LLC · Wilmington, DEBuilt 1965 · S/N 17253874 N3706UBrownfield Ken F · Boonville, MOS/N 18255106 N3707LPropwash Aviation LLC · Midland, MIBuilt 1965 · S/N 17253876 N3707RHartsfield Amy G · Pace, FLBuilt 1966 · S/N 17255507 N3708JBormann Wayne T · Valley Center, KSBuilt 1966 · S/N 15065008 N3708RNeufeld Henry F · Brownfield, TXBuilt 1966 · S/N 17255508 N3709FWeaver Jerry T Jr Trustee · Anchorage, AKBuilt 1966 · S/N 17255204 N3709JBoughter William C · Port Townsend, WAS/N 15065009 N3709RBaillie Stephen H · Flint, MIBuilt 1966 · S/N 17255509 N3709UMoser Scott M · Pisgah Forest, NCS/N 18255109 N370LATurning Point @ Sonrise Inc · Hartsville, TNBuilt 1964 · S/N 17251995 N370SNesbit Stephen W · Hemphill, TXBuilt 1968 · S/N 17700692 N3710FDavis Charles Arthur Wesley · Petersburg, AKS/N 17255205 N3710LRegistered aircraftS/N 17253879 N3710UFollette Aviation LLC · Scottsdale, AZBuilt 1963 · S/N 18255110 N3711FMission Aviation Training Academy · Arlington, WABuilt 1966 · S/N 17255206 N3711SWittco Aero LLC · Vancouver, WAS/N 15062988 N3712LNoble Todd D · Hudson, INBuilt 1965 · S/N 17253881 N3712UVarian Dennis D · West Lafayette, OHBuilt 1963 · S/N 18255112 N3713FDavis Jeffery S · Oregon City, ORBuilt 1966 · S/N 17255208 N3713RTroglio Joseph A · Peoria, ILBuilt 1966 · S/N 17255513 N3713UDaggy Curt L III · Red Bluff, CABuilt 1963 · S/N 18255113 N3714FSwearengen Sally · Tunica, MSBuilt 1966 · S/N 17255209 N3714LArizona Aircraft Leasing LLC · Mesa, AZBuilt 1965 · S/N 17253883 N3714USchaffer John Paul · Prior Lake, MNBuilt 1963 · S/N 18255114 N3715JSmoot Nathan · Fairbanks, AKS/N 18255115 N3715RFriederich Claudio T · Honolulu, HIBuilt 1966 · S/N 17255515 N3716UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1963 · S/N 18255116 N3717FLake Area Technical College · Watertown, SDBuilt 1966 · S/N 17255212 N3718JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1966 · S/N 15065018 N3719JVink Ray · Phoenix, AZBuilt 1966 · S/N 15065019 N3719LHurst Edward E · Southlake, TXBuilt 1965 · S/N 17253888 N3719UOlsen Marvin J · Kent, WABuilt 1963 · S/N 18255119

Back to AD 72-03-03 R3