AD 72-03-03 R3
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
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.
N373KVCrystalinas Johnathan · Rancho Cordova, CAN3740FLavalley Asset Management · Potsdam, NYN3740JHersom Jeffrey T · Helena, MTN3740RRhodes Samuel R · Bonne Terre, MON3740UFlight Club 502 Inc · Louisville, KYN3741FMclanahan John P · Culpeper, VAN3741JSharp Ruth · Clarksville, TNN3741RAbecca Corp · Jackson, MIN3742JLow Cost Flying LLC · Chandler, AZN3743FRohde William B · Homer, NEFirst renewal noticeN3743LAero Flight Two LLC · Peoria, AZN3743UHughes Kathryn G · Council, IDN3743YCooper Jess D · Spanaway, WAN3744LAir Jeffery LLC · Aledo, TXN3745LMaxey Lonnie C · Powell, TNN3745RDodds Timothy E · Salmon, IDN3745UAnglemyer Mark · Piketon, OHN3746JCrandall Lloyd G · Lake City, MIN3746LBygd Sherman O · New Richmond, WIN3746RPearson Eric · Wills Point, TXN3746UUltimate Internet Access Inc · Wrightwood, CAN3746YWeed James A · Suwanee, GAN3747JRegistration Pending · Bay Harbor Islands, FLRegistration pendingN3747LN3747l LLC · Sonora, CAN3747YCenturion Aviation Nevada LLC · Sparks, NVN3748FMcdonald David R · Duluth, MNN3748HVoth Michael K · Lynchburg, VAN3748RRotormate LLC · Royse City, TXN3748UChristy Allen C · Farmington, NMN3749FLeduc Kramer LLC · Live Oak, FLN3749JLove Duane Anthony · San Rafael, CAFirst renewal noticeN3749LWilcox James F · Garrison, NDN3749YWestwind Homes Inc · Twin Falls, IDN3750FGrubbs Richard T · Spring, TXN3750JEagle East Aviation Inc · North Andover, MAN3750RN3750r LLC · Guthrie, OKN3750YMurphy Mark · Belleair, FLN3752FCopper River Airmotive LLC · Copper Center, AKN3752JLudwig Daniel C · New Rockford, NDN3752RMccoy Gregory K · Wichita, KSN3752URegistered aircraftN3753JWallin Joshua M · Moreno Valley, CAN3753LKroutil David W · Hilmar, CAN3753RCounts Sean M · Largo, FLN3753YWolfe Christopher D · Gilbert, AZN3754FTrees Joshua S · Italy, TXN3754LBuist Gordon G · Southbury, CTN3754RVandiver James A · Rome City, INN3754YSullivan Eugene M · Cotter, ARN3755LNorcal Flight Center LLC · Lincoln, CA
Back to AD 72-03-03 R3