AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N5690HBackus-Flint Judith A · Blanchard, MIN5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKN5690UPena Flight Partners LLC · Oakland, CAN56918Virgil Osvaido J · Glendale, AZN5691MBrowning Robert F · Washington, DCN5691PCoady Michael · Taylorville, ILN5692HHarma Michael J · Ironwood, MIN5692QOpen Air Aviation LLC · Colorado Springs, CON5692WFollmer Harvey C III · Trout Run, PAN5692YSilverado Sales Inc · Orem, UTN5693HDorsay Edward R · Memphis, TNN5693QKaufman Ben · Liberty, UTN5693SChupp David · Abbeville, SCN5693ZRustin Cody W · Reynolds, GAN56943Mcdowell David M · El Cajon, CAN56947Wings Of Hope · Chesterfield, MON5694AStyer David B · Pendleton, ORN5694HTischer William D · Shoreview, MNN5694UPlencner Robert E · Round Lake Beach, ILN5694WLange James R · Tempe, AZN56950Bodily Kent A · Washington, UTN56957Payne Glenn · Oregon, MON56958Jackson Michael L · Nixa, MOFirst renewal noticeN5695QBabb Douglas L · Telford, PAN5695W95whiskey LLC · Georgetown, MAN56964Lafollette Larry E · Strafford, MON56966West David A · Astoria, ORN5696HVaughan William R IV · Benton, MSN5696MHubbard Benjamin L · Quogue, NYN5696QTrilogy Alliance Group LLC · Kearney, NEN5696WGiglio Tom J · South Boston, VAN56970Simoneau Todd · Sandown, NHN56972Eby Aviation LLC · Duluth, GAN56976Tate Bird L Jr · Hammond, NYN56977Evans Holland L · Danielsville, GAN56978Brindley James G · Collinsville, ALN5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALN5697QReed Timothy W · Terrell, TXN5697ZLink James L · Raleigh, NCN56986Loya Armando · Whittier, CAN56987Ravotti Air LLC · Leechburg, PAN56988Hillerman Paul J · Vinita, OKN56989Kenny Zachary D · Herndon, VAN5698QCaughell David S · Bartlesville, OKN5698SNewell Gary A · Colmar, PAN5698UNorby David S · Gooding, IDN5698WBurkett Aviation LLC · Hampstead, NCN56991Schneider Stephen C · Denton, TXN56992Attebery Larry J · Caldwell, IDN569932c Fun Aviation LLC · Dallas, TX
Back to AD 90-04-06 R1