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.
N576FLRocky Top Corp · Erin, TNN576KAtp Aircraft 3 LLC · Wilmington, DEN576PAClear Skies LLC · Whitehall, PAN576SPSo Cal Leasing LLC · El Cajon, CAN5770HBellino Dominic P · Florence, CON5770QJohnson Darryl · Fowler, CON5770VAkins Terral S · Grain Valley, MON5770WGallo Danny P · Nashotah, WIN5771DEllison Stephen · Anchorage, AKN5771HHill Bruce T · Ramona, CAN5771QLuchterhand Charles · Salem, ORN5771VLow & Slow Aviation LLC · Westminster, CON5771WCrumpton Bradley N · Caddo Mills, TXN5771ZDavenport Brad E · Eagle River, AKN5772DLong Randy B · Coleman, TXN5772QTweten Gary L · Glasgow, MTN5772UBernstein Matthew D · North Charleston, SCN5772VSouthwest Truck Parts Inc · Pratt, KSN5772WBallard Gary H · Soddy Daisy, TNN5773EOppegard Nicholas · Eagle River, AKN5773HSchneider Beth A · Midway, UTN5773MHulslander Taylor · North Pole, AKN5773QGunnerson Spencer · Murfreesboro, TNN5773UNelson Francis A · Winchester, VAN5774HPerron Ted J · White Bear Lake, MNFirst renewal noticeN5774LHickman Robert D · Mobile, ALN5774ZLiming Danny O · Andrews, TXN5775EGates Rebecca S · GeorgetownNon-citizen corporation, flight hours not reportedN5775QSinger David · Vandalia, OHN5775UBravo Tango Aviation · Spearfish, SDN57761Air Giblinski LLC · Sedgwick, KSN5776HMastre Joshua M · Soldotna, AKN5776LCollins Timothy · Northfield, MNN5776UBrainard Gary Keith · Olney, ILN57777Thorsgard Keith A · Mcville, NDN5777LSessums David L · Seabrook, TXN5777UFossa Matthew A · Pensacola, FLN5777VDe La Garza Jimmy · Granbury, TXN5777WMaschek Anothony Q · Killeen, TXN57787Shoultys Shawn P · Denali Park, AKN5778QPars Avn Corp · Wilmington, DEN5778VGlenn Larry D · Reynoldsburg, OHN5778ZWhelan Cynthia Vs · Seneca, SCN57792Arizona Game & Fish Dept · Phoenix, AZN5779DAltenburg Scott J · Anchorage, AKN5779FScheer Abraham · Milton, DEN5779HKelly David L · Pendleton, ORN5779PLechner Kevin P · Wurtsboro, NYN5779ZSvec Adolph R · Marengo, ILN577CMEllison Ranching Co · Elko, NV
Back to AD 90-04-06 R1