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.
N65752Owens Flight Training LLC · Lafayette, LAN65753Flying Bulldogs LLC · Joplin, MON65756Brown Justin M · Peachtree City, GAN65758American Patrols Inc · Midland, TXN6575EPoutre Robert P · Osceola, WIN6575PTrade Winds Aviation Holdings LLC · Lewes, DEN6575QRegistered aircraftN6575WStrouse Joshua L · Columbia, MON65767Chu'S Sky LLC · Brandon, FLN6576BMoore Roger W · Poinciana, FLN6576JPa28 Nevada LLC · Incline Village, NVN65770Thompson Clinton J · Greer, SCN65772Sky Adventure LLC · Bartlett, TNN65773Ial Corp · Lewes, DEN65775Ristrim Eric · Henderson, NVN65776Meridian Aviation Holding Company · Teterboro, NJN6577HRegistered aircraftN6577JSpark Solar Power LLC · Chandler, AZN6577QForce Gary · Granbury, TXN6577RAir Echo Alpha 51 LLC · Erie, CON6577UKoehler Richard E · Port Orange, FLN6577WAdventist World Aviation · Wilson, NCFirst renewal noticeN65784Ohio State University · Columbus, OHN65789Burket George C · North Hollywood, CAN6578JMalone W Paul · Coulee City, WAN6578NOxford Sherman D · Flower Mound, TXN6578RGrinnell Herbert W · Oroville, CAN6578UJbl Aeronovia LLC · Kent, WAN6578WHanauer Keith A · Bloomfield, INN65794Baker Curtiss L · Kinston, NCN65798Samons David M · Phoenix, AZN6579JBender Auto Body Inc · Middleville, MIN6579PDantas Ricardo J · Apple Valley, CAN6579URegistered aircraftN657CAOlson David A · New Underwood, SDN657MCPotts Robert G Jr · Oak Hill, FLN657MJRumiano Keith D · Vina, CAN657NDUniversity Of North Dakota · Grand Forks, NDN657RVHart Tom J · Aurora, ORN657SCKruse Shannon E · Republic, MON657SPChristiansen Aviation LLC · Wilmington, DEN657SRRm & Lp Ltd · Azalea, ORN657TBWilson Adrian H · Orange Park, FLN6580JPoppy Wayne J · New London, WIN6580LHigh Wing Air Services LLC · Merritt Island, FLN6580WPanero Philip J · Merritt Island, FLN65813Northwest Wings LLC · Hillsboro, ORN6581PPeavey Dayanna · Charles Town, WVN6581RMyrtle Beach Dustless Blasting Llp · Loris, SCN6581VSimmons Claude E · Ocracoke, NC
Back to AD 90-04-06 R1