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.

N3385YNoah Aviation LLC · Ellabelle, GABuilt 1962 · S/N 18254385 N3386FN3386f Flying Club Inc · Pickerington, OHBuilt 1966 · S/N 18257386 N3387FChristensen Robert F · Gillette, WYBuilt 1966 · S/N 18257387 N3387JMy Piper Pacer LLC · Everett, WAS/N 15066087 N3387RSkypartners LLC · Buhler, KSBuilt 1967 · S/N 18258687 N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687 N3387USkynick Enterprises Inc · Tarzana, CAS/N 18254787 N3387YBhogal Balvinder S · Biloxi, MSBuilt 1962 · S/N 18254387 N3388RFamily Air Fares LLC · Wilmington, DEBuilt 1967 · S/N 18258688 N3388SShaffer Barbara J · Franklin, KYBuilt 1969 · S/N 21059188 N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688 N3388UMenard Charles H · Grand Blanc, MIBuilt 1963 · S/N 18254788 N3388YMeeks Peris M · Gardena, CAS/N 18254388 N3389UThompson Anthony D Trustee · Rockwall, TXS/N 18254789 N338LMSisk Stephen A · Greenville, ILBuilt 1968 · S/N 18259244 N3390FRodgers Christian Joseph · Ormond Beach, FLS/N 18257390 N3390JVandyke Dennis C · Rose Hill, VABuilt 1967 · S/N 15066090 N3390TTucker Lon R · East Peoria, ILBuilt 1967 · S/N 17700690 N3390YHead John T Jr · Port St Joe, FLS/N 18254390 N3391FKingston Terry D · Irving, TXBuilt 1966 · S/N 18257391 N3391TCardinal Wings LLC · Middletown, DEBuilt 1968 · S/N 17700691 N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693 N3394RCurren Patrick V · Green Bay, WIBuilt 1967 · S/N 18258694 N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694 N3394YNolt Ivan M · Mount Solon, VABuilt 1962 · S/N 18254394 N3395JFly N Style · Parkland, FLBuilt 1967 · S/N 15066095 N3395RJohnston Osceola Holdings LLC · Dallas Center, IABuilt 1968 · S/N 18258695 N3395YTriple J Aviation · East Quogue, NYS/N 18254395 N3396FThompson Patrick J · Evanston, WYBuilt 1966 · S/N 18257396 N3396RSimmons Craig · Houston, TXBuilt 1967 · S/N 18258696 N3396YPlane Fun Inc · Lewes, DEBuilt 1962 · S/N 18254396 N3397FKerns Aaron R · Sullivan, INBuilt 1966 · S/N 18257397 N3397JZwerko Sherri · South Plainfield, NJBuilt 1967 · S/N 15066097 N3397RKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1967 · S/N 18258697 N3397SMcrae Richard · Kent, WABuilt 1969 · S/N 21059197 N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697 N3398YBobbitt Michael · Lamont, OKBuilt 1962 · S/N 18254398 N3399FVetter T Kevin Trustee · Phoenix, AZBuilt 1966 · S/N 18257399 N3399RGleason Joseph P · Knoxville, TNBuilt 1967 · S/N 18258699 N3399UWorley Dan J · Perris, CABuilt 1963 · S/N 18254799 N339CPHenley Mark L · Emelle, ALBuilt 1966 · S/N 18257470 N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784 N33DBBowers Albert Joseph Jr · Aberdeen, MDBuilt 1970 · S/N 17701451 N33DMGray Chad T · Garden Valley, IDBuilt 1968 · S/N 18259170 N33DPB&C Cejka Real Estate LLC · Sioux City, IABuilt 1967 · S/N 15066465 N33EEDes Moines Skydivers LLC · Des Moines, IABuilt 1969 · S/N 18259998 N33GJOliser Andras · Savannah, GABuilt 1964 · S/N 205-0538 N33KYBurnette Ric A · Sebastian, FLS/N 17253910 N33MGTopeka Flyers Inc · Topeka, KSBuilt 1969 · S/N 18259660 N33REChapman Richard B · Granbury, TXBuilt 1969 · S/N 18259682

Back to AD 72-03-03 R3