AD 72-03-03 R3
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
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.
N8087LBawden Scott L · Saint George, UTN8087SBridges Jeffrey · Allen, TXN8088LMarciano Raymond P · Cleveland, OHN8088SRutherford Thom J · Birchwood, WIN80899Pedersen Herbert N · Willard, UTFirst renewal noticeN8089FFlying A Aviation LLC · Archer City, TXN8089GWellman Steven R Trustee · Englewood, FLN8089SBleier Rachel · Grayslake, ILN808BCMahanawai Lele LLC · Honolulu, HIN808ESStaples Safari Ministries Outreach · Clayton, WAN808KSDucks Are Free LLC · Salina, KSN808RLCtr Assets LLC · Dawsonville, GAN8091GWood Kim W · Tucson, AZN8091LSzarek Carlee B · Los Osos, CAN8091ZFahlbusch Marius J · Snohomish, WAN8093FHardy Peter Nicholas · Los Osos, CAN8093LNevins Mark B · Gresham, ORN8095SKimball James D · Osceola, IAN8097FBlue Sky Powers LLC N8097f LLC · Dover, DEN8097LPeters Aero Plus LLC · Freeland, MIN8098LJordan James R Trustee · Hermon, MEN8099LMateaki Koreen · Anchorage, AKN80PPN80pp LLC · Titusville, FLN80SMSkyward Aviation Enterprises LLC · Raleigh, NCN8100SHigh Exposure Inc · Wilmington, DEN8101LDickson Aaron M · Arkadelphia, ARN8101UWeirick Kelly M · Morganton, NCN8102FFerrier Robert Clifford · Lindsay, CAN8102ZCrestview Estate LLC · Greenwood, SCN8103LSoaring Mrt LLC · Lake Charles, LAN8103ZProsser Joel R · Sacramento, CAN8104FDunham John P · Colorado Springs, CON8104SFlowers Tony C · Panhandle, TXN8104UMellen Dennis L · Peoria, ILN8104ZNegris James R · Mazama, WAN8105LIowa Skyhawk LLC · Charles City, IAN8106FHoward Mason · Phoenix, AZN8106SMay Jason L · Alva, OKN8106ZWilliamson Gary S · Lakeport, CAN8107LConrad Adam C Jr · Duncansville, PAN8107SChalmers Ashley · Manalapan, NJN8107ZReid Brian M · Boise, IDN8108FSale Reported · Greenback, TNSale reportedN8108SGray Ronald W · Hooker, OKN8109LVajgrt Richard Eugene · Mobile, ALN8109SWillis Quinton Blair · Murfreesboro, TNN810CLMathews Roy E · Sparta, MIN810KTDavis John M · Fairhope, ALN8110LMiller Brian T · Savage, MNN8110SV B Aviation LLC · Peachtree City, GA
Back to AD 72-03-03 R3