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.

N3368SForbes Amanda M · Huachuca City, AZBuilt 1969 · S/N 21059168 N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668 N3368UZeigler Ryan C · The Dalles, ORBuilt 1963 · S/N 18254768 N3369FJ P Aero Holdings Inc · Carson City, NVS/N 18257369 N3369RFenton Flyers Inc · Hillsboro, MOBuilt 1967 · S/N 18258669 N3369SC-210 Lc · Atlantic, IABuilt 1969 · S/N 21059169 N3369TBauer Charles · Graceville, MNS/N 17700669 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N336RSAirspeed Marketing LLC · Phoenix, AZS/N 17252228 N3370UBriannas Wings Of Passion Foundation Inc · Magalia, CABuilt 1963 · S/N 18254770 N3370YBrink Brittnie L · Baldwin, WIBuilt 1962 · S/N 18254370 N3371FRavens Rebuilders Inc · Ellenboro, WVS/N 18257371 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N3371YChavers Finley L · Newnan, GABuilt 1962 · S/N 18254371 N3372FSwanner Robert Craig II · Water Valley, MSBuilt 1966 · S/N 18257372 N3372SBmf Services USA LLC · Satellite Beach, FLBuilt 1969 · S/N 21059172 N3372ULeading Edge Operations LLC · Knoxville, TNBuilt 1963 · S/N 18254772 N3373BManley Steven T · Dallas, TXBuilt 1965 · S/N 17253577 N3373RSkylane N3373r LLC · Rancho Cucamonga, CABuilt 1967 · S/N 18258673 N3373SWestern Metal Products LLC · Ellensburg, WABuilt 1964 · S/N 18255390 N3374SCcf Ventures Inc · Bangor, MEBuilt 1969 · S/N 21059174 N3374TLazy Eight LLC · Kalispell, MTS/N 17700674 N3374UMurphy & Son Construction Inc · Brownsville, VTBuilt 1963 · S/N 18254774 N3374YRegistered aircraftBuilt 1962 · S/N 18254374 N3375FKintner William R · Port Angeles, WABuilt 1966 · S/N 18257375 N3375RRoyellair LLC · Stone Mountain, GABuilt 1967 · S/N 18258675 N3376RStumm Robert W · Cadott, WIBuilt 1967 · S/N 18258676 N3376YFly Greater Breezewood LLC · Clearville, PABuilt 1962 · S/N 18254376 N3377JGriffith Scott · Hewitt, TXBuilt 1967 · S/N 15066077 N3377RLonestar Aeronautics LLC · Paige, TXBuilt 1967 · S/N 18258677 N3378UJeppson Edward M · Nephi, UTBuilt 1963 · S/N 18254778 N3379UJames Mccullough · Hempstead, TXBuilt 1963 · S/N 18254779 N337DMMcwhorter Michael S · Fortuna, CABuilt 1968 · S/N P206-0471 N337GFLewis John P · Alachua, FLBuilt 1969 · S/N 17258349 N337XCHoover Rodney A · Wasilla, AKBuilt 1966 · S/N 15062891 N3380JEsparza Edel · Chula Vista, CABuilt 1967 · S/N 15066080 N3380RHunter Robert R · Springville, PABuilt 1967 · S/N 18258680 N3380YLaramie Flying Club Inc · Laramie, WYBuilt 1962 · S/N 18254380 N3381FAttema Symon Nmi · Norco, CABuilt 1966 · S/N 18257381 N3381UCenter Of Excellence Corp · Cheyenne, WYBuilt 1963 · S/N 18254781 N3382RWatch Out LLC · Scottsdale, AZBuilt 1967 · S/N 18258682 N3382YJenkinson John III · Lakin, KSBuilt 1962 · S/N 18254382 N3383RDeatley Derek · Mohave Valley, AZBuilt 1967 · S/N 18258683 N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183 N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683 N3383YJohnson Brian B · Monroe, LABuilt 1962 · S/N 18254383 N3384R3384 Romeo LLC · Jackson, MOBuilt 1967 · S/N 18258684 N3384YOliveira John S · Plant City, FLBuilt 1962 · S/N 18254384 N3385JGonzales Mark S · Dothan, ALS/N 15066085 N3385RHill David A Jr · Needham, MABuilt 1967 · S/N 18258685

Back to AD 72-03-03 R3