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.

N4909UGarner Howard E · Bonifay, FLBuilt 1965 · S/N 21058609 N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493 N4910UN4910u LLC · Cushing, OKBuilt 1965 · S/N 21058610 N4913UGarvey F Patrick · Churubusco, INBuilt 1965 · S/N 21058613 N4914UCaldwell Gregg P · Desert Hot Springs, CAFirst renewal noticeBuilt 1965 · S/N 21058614 N4916FSkaggs Steven L · Winters, CABuilt 1966 · S/N U206-0616 N491AFMeyer Terry L · Wayne, NEBuilt 1968 · S/N 18258754 N491CCBarbee Johnny Lee · Fort Stockton, TXBuilt 1971 · S/N 18260654 N4921FCa Aviation 172 LLC · Santa Barbara, CAS/N U206-0621 N4924UScheren Raymond D · Johnson, VTBuilt 1965 · S/N 21058624 N4927UBetz Brett A · Reminderville, OHBuilt 1965 · S/N 21058627 N4934USatriana Robert L · Belen, NMBuilt 1965 · S/N 21058634 N493BTRegistration Pending · Deltona, FLRegistration pendingBuilt 1975 · S/N 17702318 N493SHForsman David G Co-Trustee · South Haven, MNBuilt 1968 · S/N 17256881 N4941FPaddock Levi · Springfield, ORS/N U206-0641 N4942UCenturion LLC · Bonney Lake, WABuilt 1965 · S/N 21058642 N4944PReed John Richard · Charleston, ILBuilt 1964 · S/N 18255703 N4948URegistered aircraftBuilt 1965 · S/N 21058648 N494RAAstra Integrated Technologies LLC · Rockledge, FLBuilt 1967 · S/N 15066996 N4951FAerial Services Inc · Cedar Falls, IAS/N U206-0651 N4957FBravo Hotel LLC · Lewes, DEBuilt 1966 · S/N U206-0657 N495RAGabbard Derek L · Paint Lick, KYS/N 15067052 N4960RUnited States Air Force Owner · Cannon Afb, NMBuilt 1967 · S/N 17256296 N4960UHopkins Breck G · North Little Rock, ARBuilt 1965 · S/N 21058660 N4962FEvans Dick G Trustee · Riverside, CABuilt 1966 · S/N U206-0662 N4963UAllen Shanda · Aynor, SCBuilt 1965 · S/N 21058663 N4964FTeam Builders Inc · Carson City, NVBuilt 1966 · S/N U206-0664 N4967FMile Hi Skydivers Inc · Longmont, COBuilt 1966 · S/N U206-0667 N4968UGreen Brandon K · Eufaula, ALBuilt 1965 · S/N 21058668 N4969RUnited States Air Force Owner · Offutt Afb, NEBuilt 1967 · S/N 17256323 N4969UTallgrass Aviation LLC · Sharon Springs, KSBuilt 1965 · S/N 21058669 N4971RScherer Sid S · Napa, CABuilt 1967 · S/N 17256325 N4972FTomahawk Aviation LLC · Reno, NVBuilt 1966 · S/N U206-0672 N4972RUnited States Air Force · Apo, APBuilt 1967 · S/N 17256326 N4973UFlightpath Leasing LLC · Tallahassee, FLBuilt 1965 · S/N 21058673 N4974RMcpherson Marvan T · Oklahoma City, OKS/N 17256328 N4976UMoro Jim · Naples, FLS/N 21058676 N4977UBaker Bryan D · Anderson, CABuilt 1965 · S/N 21058677 N4978FLabahn Ty L · Sherwood, ORBuilt 1966 · S/N U206-0678 N4979RUnited States Air Force · Offutt Afb, NEBuilt 1967 · S/N 17256333 N497RAMartin Anthony M · Beebe, ARBuilt 1967 · S/N 17256273 N4981RUnited States Air Force (Owner) · Offutt Afb, NEBuilt 1967 · S/N 17256335 N4983RAmerican Flight Museum · Topeka, KSS/N 17256337 N4985RUnited States Air Force Owner · Clovis, NMBuilt 1967 · S/N 17256339 N4986FStanley Cherri · Pearland, TXS/N U206-0686 N4987RUnited States Air Force Owner · Offutt Afb, NEBuilt 1967 · S/N 17256341 N49885Lilja Daniel R · Plains, MTBuilt 1971 · S/N R1720156 N4988FBielefeld James L · Kenai, AKBuilt 1966 · S/N U206-0688 N4989RLansing Community College · Mason, MIBuilt 1967 · S/N 17256343 N498AKThompson James A · Ketchikan, AKBuilt 1971 · S/N 15072505

Back to AD 72-03-03 R3