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.
N46334Youngblood Michael A · Atlanta, GAN46338Triad Aviation Academy LLC · Greensboro, NCN46342Gernand Charles E · Hopeston, ILN46344Nordick Brett A · Glyndon, MNN46345Hellgamite Inc · Dover, DEN46346Registered aircraftN46349Third Step 1 LLC · Gilbert, AZN4634FCardinal Air LLC · Wynantskill, NYN4634LGs Family Holdings LLC · Middletown, DEN4634XSorg Daniel T · Columbus, INN46351Ajayi Samuel · Fredericksburg, VAN46352Moss James H · Anchorage, AKN46355White Wings Air Inc · Jacksonville, FLN46374Marcotte Jeffrey N · Bossier City, LAN46378Northwoods Air LLC · Levant, MEN46381Oldis Frank A · Taylors, SCN46382Cognition LLC · Billings, MTN46385R A Marsh Flying Club LLC · Williamson, GAN4638FSkydive Lake Tahoe LLC · Tahoe City, CAN4638XHoward David R · Oconomowoc, WIN46390Gerber Aviation LLC · Winter Haven, FLN46391Stark Rickie N · Princeton, MNN46392Tedron Air Ltd · Setauket, NYN46396Kpa LLC · Kalamazoo, MIN46399Rutter Clarence W III Trustee · Norman, OKN4639LHalle Michael P · Livingston, TXN4639XCjs Aviation Consulting LLC · Phoenix, AZN46401Bandstra Larry J · Heath Springs, SCN46404Coastal Fliers Inc · El Cajon, CAN46407Solis Joseph G · Poulsbo, WAN4640FDouglas Mark S DBA · Bellingham, WAN4640XStern Roger A · Kearny, AZN46410Valentine Terence · Glennallen, AKN46415Hage Michael J · The Villages, FLN46418Batesquire LLC · Clanton, ALN46419Rodgers Bruce W · Ramona, CAN4641LRegistration Pending · El Reno, OKRegistration pendingN46420Frontier Environmental Solutions Inc · Inyokern, CAN46423Parrish Aviation Flight Academy LLC · Southlake, TXN4642LJordan Jason A · Portland, MEN46430J & Dk LLC · Overland Park, KSN46433Plummer Fred C · Normal, ILN46435Hawkins County Sports Wings Inc · Kingsport, TNN46436Aero Science International LLC · Martinez, GAN46437Arizona Active Air LLC · Yuma, AZN4643XTaylor Aaron B · Leander, KYN46440Engelskirger Karl D · Valley City, OHN46442Lott Terence D · Florence, MSN46448Mac Air Inc · Farmington, MON46449Tilma Flying Club Inc · Moscow, ID
Back to AD 72-03-03 R3