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.

N2527LWooten Craig J · Campobello, SCS/N 17255727 N2527QTwenty Inc · Wilmington, DES/N 18257727 N2528LWings Of Faith · Stevensville, MTBuilt 1966 · S/N 17255728 N2528RHutchens Robert L II · Mocksville, NCBuilt 1967 · S/N 18258228 N2528XButcher Collin E · Freeport, TXBuilt 1964 · S/N P206-0028 N2530LSholes Lance M · Oregon City, ORBuilt 1966 · S/N 17255730 N2530RHines David L · Lancaster, CABuilt 1967 · S/N 18258230 N2530VAnderson Jeffrey L · Harrisburg, SDBuilt 1974 · S/N 177RG0604 N2531LAiken Justin M · Arden, NCS/N 17255731 N2532RDelong Erika Dee · Forest Lake, MNBuilt 1967 · S/N 18258232 N2532XTwo River Airspray LLC · Hallock, MNBuilt 1964 · S/N P206-0032 N2533QBusse Alana · Thousand Oaks, CABuilt 1966 · S/N 18257733 N2533RAdams Michael B · Scottsdale, AZBuilt 1967 · S/N 18258233 N2533VHasselvander Brian K · Columbia, MSBuilt 1974 · S/N 177RG0605 N2534RRobuck Dale J · Knoxville, IABuilt 1967 · S/N 18258234 N2535QDerodeff Stephan A · Nipomo, CABuilt 1966 · S/N 18257735 N2535VRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1974 · S/N 177RG0606 N2536LLink Kim D · Golden Valley, NDBuilt 1966 · S/N 17255736 N2536QWiebe Tim · Newton, KSBuilt 1966 · S/N 18257736 N2536XLouscher Steven Trustee · Paullina, IABuilt 1964 · S/N P206-0036 N2537LOneill Timothy J · Clyo, GABuilt 1966 · S/N 17255737 N2538R1 Point 21 Gigawatts LLC · Auburn, WABuilt 1967 · S/N 18258238 N2538VDavidson Joel R · Granville, NYS/N 177RG0607 N2539RWillard John E Jr · Rockwood, MEBuilt 1967 · S/N 18258239 N2540RFreeman Josh · Turtle Lake, NDBuilt 1967 · S/N 18258240 N2541XEco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N P2060041 N2542RThordarson Gudsteinn T · La Porte, INBuilt 1967 · S/N 18258242 N2543RSaddlery Air Inc · Des Moines, IABuilt 1967 · S/N 18258243 N2544RBill Church Real Estate LLC · Midland, MIBuilt 1967 · S/N 18258244 N2545RYad Aviation LLC · Cherry Hill, NJBuilt 1967 · S/N 18258245 N2545YCalifornia Aviation Services Inc · Riverside, CABuilt 1965 · S/N 17252552 N2546RStephani Timothy Michael · White Lake, WIBuilt 1967 · S/N 18258246 N2547LDavis Tyler · Laurinburg, NCBuilt 1966 · S/N 17255747 N2547XOber John A · Candor, NYS/N P206-0047 N2548RHuertas Andrew · Van Nuys, CABuilt 1967 · S/N 18258248 N2549LSiemon Mark R · Belle Plaine, MNBuilt 1966 · S/N 17255749 N254KMFowler Michael J · Golden Valley, MNBuilt 1968 · S/N 17701076 N2550LWooten Craig J · Campobello, SCS/N 17255750 N2550RSmalldridge Jonathan D · Arcadia, CABuilt 1967 · S/N 18258250 N2551RHendrix Casey W · Ennis, TXBuilt 1967 · S/N 18258251 N2551XMcgrath Paul · Potsdam, NYBuilt 1965 · S/N P206-0051 N2552LFirst Flight Corp · San Diego, CABuilt 1967 · S/N 17255752 N2552RHooper Jerald Ray · Parker, AZBuilt 1967 · S/N 18258252 N2552XN2552x LLC · Boulder, COBuilt 1964 · S/N P206-0052 N2553QSanders William R Jr · Lafayette, COBuilt 1966 · S/N 18257753 N2553RDepore Joseph E · Charleston, SCBuilt 1967 · S/N 18258253 N2554LAirheads Inc · Charles Town, WVBuilt 1967 · S/N 17255754 N2554RBartlett Richard H · Sussex, NJBuilt 1967 · S/N 18258254 N2554XWallin Justin · Henderson, NVBuilt 1964 · S/N P206-0054 N2555LGates Kimberly B · Kintnersville, PABuilt 1967 · S/N 17255755

Back to AD 72-03-03 R3