Skip to content

Registered aircraft · 17,028

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.

N9281GRuffner Scott A · Luray, VABuilt 1971 · S/N 18260821 N92822Roada Inc · Indio, CABuilt 1970 · S/N 18260378 N92824C182 Wv LLC · Charleston, WVBuilt 1970 · S/N 18260380 N92836Clark Wyatt · Ione, CABuilt 1970 · S/N 18260382 N9283GTexas Forever LLC · Denver, COBuilt 1971 · S/N 18260823 N92843Roehl John F Jr · Neapolis, OHBuilt 1970 · S/N 18260389 N92844Smooth Sailing Flying Club Inc · Avon, INBuilt 1970 · S/N 18260390 N92846Evans Millard D · Mobile, ALS/N 18260392 N92850Nelson Tabor K · Corona, CABuilt 1970 · S/N 18260395 N9285XBlu Kaya LLC · Austin, TXS/N 18253685 N92866Green Edward L · Chico, TXBuilt 1970 · S/N 18260403 N9286XRogne Fred A · Fallon, NVBuilt 1961 · S/N 18253686 N92881Patton Aviation LLC · Billings, MTBuilt 1970 · S/N 18260409 N92887Butler Aircraft Company · Walla Walla, WABuilt 1971 · S/N 18260413 N92895Dana Eric B · Davidson, NCBuilt 1970 · S/N 18260418 N9289XFull Send Aviation LLC · Fairview, TNS/N 18253689 N9290XPetrich John W · Metaline Falls, WABuilt 1961 · S/N 18253690 N92912Hill Charles W · Russellville, ARBuilt 1970 · S/N 18260426 N92922Perron Matthew B · West St Paul, MNBuilt 1970 · S/N 18260429 N92938Haney Christopher · Murrieta, CABuilt 1970 · S/N 18260435 N9293XRod Ricky L · El Cajon, CABuilt 1961 · S/N 18253693 N9296XJasuma Farms · Maxwell, CABuilt 1961 · S/N 18253696 N9297XJohnson Durwood D · Beaumont, TXBuilt 1962 · S/N 18253697 N9298ZFrederick Ag LLC · Humboldt, KSS/N 17701215 N929LSFlying Tigers Flight School Ltd · Houston, TXBuilt 1972 · S/N 17260660 N929RHJohnson Merlin K Trustee · Mentone, CABuilt 1964 · S/N 206-0061 N92CCCanadian Co Sheriffs Office · El Reno, OKBuilt 1965 · S/N 17253144 N92CMN92cm LLC · Genola, UTS/N 18260420 N92NAOneill Laurie A · Pinckney, MIS/N 207-00093 N92RHCrabtree Nathan J · Boise City, OKBuilt 1967 · S/N P206-0431 N92SCMorrison Neil E · Port Townsend, WABuilt 1967 · S/N R172-0211 N9300XEdwards Karen Marie · Mcminnville, ORS/N 18253700 N9301XShaunkoe LLC · Merrill, ORBuilt 1961 · S/N 18253701 N9308X5p&P LLC · Glenwood Springs, COBuilt 1961 · S/N 18253708 N9309XRigsby R W · Salisbury, NCBuilt 1961 · S/N 18253709 N930LFWanner Robin L · Lufkin, TXBuilt 1966 · S/N 21058766 N9311XLink Lance L · Concordia, KSBuilt 1961 · S/N 18253711 N9312XLewan William F · Naperville, ILBuilt 1962 · S/N 18253712 N9317WBruton Paul R · El Campo, TXBuilt 1986 · S/N U20607018 N9317XMoonshine Energy LLC · Midland, TXBuilt 1961 · S/N 18253717 N9318XTopnotch Aero Inc · Austin, TXBuilt 1962 · S/N 18253718 N9319XShepherd Joseph R · Fayetteville, GAS/N 18253719 N931MSColeman Aviation LLC · Livingston, TNBuilt 1968 · S/N 17257349 N93216East Moriches Aerial Advertising Ltd · Ridge, NYBuilt 1966 · S/N R172-0110 N9323XBertelsen Sven Erik · Gulfport, FLBuilt 1961 · S/N 18253723 N9327XHull Ray · Waynoka, OKS/N 18253727 N9332XM & D Blomquist LLC · Central Valley, UTBuilt 1961 · S/N 18253732 N9333X1927 Enterprises LLC · Overland Park, KSBuilt 1961 · S/N 18253733 N9337XValentine Richard E · Holt, FLBuilt 1961 · S/N 18253737 N9339XSedona Aviation LLC · Sedona, AZBuilt 1962 · S/N 18253739

Back to AD 72-03-03 R3