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.

N35849Gilliam Robert L · Islamorada, FLBuilt 1976 · S/N 177RG1060 N3584LKlesser Zachary S · Coronado, CABuilt 1965 · S/N 15062384 N3584UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1963 · S/N 18254984 N3584YHassler John Cameron · East Helena, MTBuilt 1962 · S/N 18254484 N35850Willke Ronald S · Edgewood, TXBuilt 1976 · S/N 177RG1061 N35852Taylor Bruce D · Cedar Rapids, IAFirst renewal noticeS/N 177RG1062 N35858Watkins Rickar D · Roseburg, ORBuilt 1976 · S/N 177RG1063 N3585FArikara Properties LLC · Beulah, NDBuilt 1966 · S/N 18257585 N3585UNieder Brady W · Anchorage, AKBuilt 1963 · S/N 18254985 N3585YSeemann Brian N · Lake Havasu City, AZBuilt 1963 · S/N 18254485 N35866Terry Kayla · Moulton, ALBuilt 1976 · S/N 177RG1065 N35869Cardinal Flyers LLC · Moriches, NYBuilt 1976 · S/N 177RG1067 N3586FRegistration Pending · Phoenix, AZRegistration pendingBuilt 1966 · S/N 18257586 N35872Kurtz David Lee · Cordele, GABuilt 1976 · S/N 177RG1068 N35879Aldrich Brad · Driftwood, TXBuilt 1976 · S/N 177RG1069 N3587FStout Colt W · Bosque Farms, NMBuilt 1966 · S/N 18257587 N35884Dake Tech Consulting Inc · San Dimas, CAS/N 177RG1070 N3588FBlue Eagle Aviation LLC · Edmond, OKS/N 18257588 N3588LVandegrift David H · St Paul, MNBuilt 1965 · S/N 15062388 N3588UBattles Danny C · Burns Flat, OKBuilt 1963 · S/N 18254988 N3589FInmon Glen A · Pontotoc, MSBuilt 1966 · S/N 18257589 N3589LSale Reported · Bloomburg, TXSale reportedBuilt 1965 · S/N 15062389 N3589YHmb Aviation LLC · St George, UTS/N 18254489 N358KSForgues Inc · Wilmington, DEBuilt 1967 · S/N 15066671 N35905Morgan George Scott · Litchfield Park, AZBuilt 1976 · S/N 177RG1074 N3590YAlexander Macy Nix · Mineral Wells, TXBuilt 1963 · S/N 18254490 N35913Allen John A · Hollister, MOBuilt 1976 · S/N 177RG1076 N35914Dunn Meghan Elizabeth · Mckinney, TXBuilt 1976 · S/N 177RG1077 N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225 N3592FArey Peter W · Great Falls, VABuilt 1966 · S/N 18257592 N3592YArcher Donald B · Artesia, NMBuilt 1962 · S/N 18254492 N35936Doncar LLC · Baden, PABuilt 1976 · S/N 177RG1081 N35939Aarons Daniel A · Berkeley, CABuilt 1976 · S/N 177RG1082 N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400 N3593UBdg Holdings Inc · Kingston, PABuilt 1969 · S/N 18259866 N35942Schlichting Mark A · Newborn, GABuilt 1976 · S/N 177RG1083 N3594FFirst Flight Corp · San Diego, CABuilt 1966 · S/N 18257594 N3595UBrinkman Eric · Phoenix, AZBuilt 1963 · S/N 18254995 N3596YHeintz Ludwig C · Covington, LABuilt 1962 · S/N 18254496 N35976Shoemaker Calvin D · Los Angeles, CAFirst renewal noticeBuilt 1976 · S/N 177RG1087 N3597FLivesay John · Pana, ILBuilt 1966 · S/N 18257597 N3597YCraig & Craig LLC · Merrillville, INS/N 18254497 N3598LBryan Aviation LLC · Peoria, AZBuilt 1965 · S/N 15062398 N3598UDunn Mark · Visalia, CABuilt 1963 · S/N 18254998 N3599YLooker Daniel M · Ferndale, WABuilt 1962 · S/N 18254499 N35RJEarles Kenneth D · Crowley, LABuilt 1966 · S/N 15062932 N35WD4lo Air & Land LLC · Damascus, ORS/N 2050234 N3600URiera Jose Gregorio · Saint Augustine, FLBuilt 1963 · S/N 18255000 N3602UBritsch Michael J · Anchorage, AKS/N 18255002 N3603LBeardsley David A · Arlington, WABuilt 1967 · S/N 17253772

Back to AD 72-03-03 R3