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.

N5852FAlvidrez Investments Group Inc · Lakewood, CABuilt 1967 · S/N 21058852 N5852GSwigart Davis Holdings Inc · Upland, CABuilt 1969 · S/N 15071352 N5852RBenien Dennis A · Napoleon, OHBuilt 1965 · S/N 17253521 N5853GJohnson Robert K · Monte Rio, CABuilt 1969 · S/N 15071353 N5853RHall Gary M · Muncie, INBuilt 1965 · S/N 17253522 N5855FOrmiston Air LLC · Kismet, KSBuilt 1967 · S/N 21058855 N5855RDonelan Matt B · Springfield, ILBuilt 1965 · S/N 17253524 N5857GWhitver Jeremy W · Ankeny, IABuilt 1969 · S/N 15071357 N5857RWaypoint Equipment LLC · Mckinney, TXBuilt 1966 · S/N 17253526 N5858RNitz Terry L · Fredericksburg, VABuilt 1965 · S/N 17253527 N5860FThomas Kirk F · Corpus Christi, TXBuilt 1967 · S/N 21058860 N5860GRegistered aircraftBuilt 1969 · S/N 15071360 N5860RSkyhawk Ventures LLC · Boise, IDBuilt 1965 · S/N 17253529 N5862RMcgowan Keegan M · San Antonio, TXBuilt 1965 · S/N 17253531 N5864FSkaw Jack E · New Auburn, WIBuilt 1967 · S/N 21058864 N5864GScarabin Jim D · Apalachicola, FLBuilt 1969 · S/N 15071364 N5864RBattle Proven Leadership LLC · Crown Point, INBuilt 1965 · S/N 17253533 N5866RNeal Edward K · Laud By Sea, FLS/N 17253535 N5867CGunnarsson Jon · Concrete, WABuilt 1970 · S/N 15072277 N5867FIndigo Of South Fl Inc · Sunrise, FLS/N 21058867 N5867GCrowley Kelly P · Mount Pleasant, SCBuilt 1969 · S/N 15071367 N5867RGoatley John E · Springfield, KYS/N 17253536 N5868RRizzo John M Sr · Sugar Land, TXBuilt 1965 · S/N 17253537 N5869FCavanaugh Gerald R · Friendswood, TXBuilt 1967 · S/N 21058869 N5872FStearns Edwin B Jr · Chandler, AZBuilt 1967 · S/N 21058872 N5872GCramer John A · Marana, AZBuilt 1969 · S/N 15071372 N5872RMckee Joseph R · Godfrey, ILBuilt 1965 · S/N 17253541 N5873FWehrman George · Covina, CABuilt 1967 · S/N 21058873 N5873R3 Points LLC · Comstock Park, MIBuilt 1965 · S/N 17253542 N5874RHammel Tyler S · Dufur, ORBuilt 1965 · S/N 17253543 N5875RHepburn Joseph C · Towanda, KSBuilt 1965 · S/N 17253544 N5876RJasmer Craig G · Puyallup, WABuilt 1965 · S/N 17253545 N5877GClegg Stephen A · Port Orange, FLBuilt 1969 · S/N 15071377 N5877RRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1965 · S/N 17253546 N5878FVanreeth Philip J Jr · Woodstock, ILBuilt 1967 · S/N 21058878 N5881RRengel Ronald J · Mundelein, ILBuilt 1965 · S/N 17253550 N5882RGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17253551 N5883GDerry Delmar D · New Market, IABuilt 1969 · S/N 15071383 N5886RZimmer James D · Mason City, NEBuilt 1965 · S/N 17253555 N5887FDe Leon Christopher · Donna, TXBuilt 1967 · S/N 21058887 N5888RTepper Steve D · Stayton, ORBuilt 1965 · S/N 17253557 N5889RPatkotak Crawford A · Barrow, AKS/N 17253558 N588LCProdonor LLC · Phoenix, AZBuilt 1965 · S/N 17253895 N5890GPommer Timothy J · Kittanning, PABuilt 1969 · S/N 15071390 N5890RYell Christopher R · Williamsburg, KYBuilt 1965 · S/N 17253559 N5891GWebb Christopher L · Burns, TNBuilt 1969 · S/N 15071391 N5891RTun Bay Inc · Wasilla, AKBuilt 1966 · S/N 17253560 N5894RMurray Kevin D · Moneta, VABuilt 1965 · S/N 17253563 N5895RBernhard Sterling · Harper, TXBuilt 1965 · S/N 17253564 N5896GYtsera Air Fred LLC · Lyndonville, VTBuilt 1969 · S/N 15071396

Back to AD 72-03-03 R3