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.
N8153CHelileasing Inc · Las Vegas, NVN8153NStacy Blackburn · Milton, FLN8153WClear Sky Aviation LLC · Oviedo, FLN8154JCarter Flygare Inc · Sacramento, CAN8154NArmosa Studios LLC · Franklin, TNN8154WBennink James · Spring Lake, MIN8154YRawson Aviation LLC · Collinsville, OKN81552Oestreich Bret M · Owasso, OKN8155EOneill Jon · Argyle, TXN8155GSaraceno Robert Jr · Lynnfield, MAN8155HPeckerhead Motorcycle Racing LLC · Gainesville, GAN8155NThompson Trent A · Forsyth, MTN8155WCochran William J · Williamson, GAN8156DMoyle Matthew L · Soldotna, AKN8156NMoreau Donald G · Dayton, TXN8156RGhazarian Christopher L · North Hollywood, CAN8156TAzcona Rogelio G · Okeechobee, FLN8156WLandis Michael D · Jonestown, PAN81577Juhl Wilbur D · Roundup, MTN8157CAfshar George · Trabuco Canyon, CAN8157NBolton Jeffrey · Mont Belvieu, TXN8157WFippin Brett Thomas · Brentwood, CAN8157YSchmidt Zachary P · Raleigh, NCN81586Elbarki Maged A · Boca Raton, FLN8158DBates James H · Lakeview, ORN8158NHorizon Aviation LLC · Brooks, GAN8158WMills Jeroldine C · Altaville, CAN8158ZLee Randy A · Gulf Shores, ALN8159KQ G Aviation Of America Inc · Fort Collins, CON8159WDowner Jesse S · Acampo, CAN815DFOglesby Richard A Jr · Atlanta, GAN815DKBas Part Sales LLC · Greeley, CON815EHBuell Travis · Harper, TXN815KSPenner Bruce Wade · Hot Springs, SDN815KTFrase Kenneth E · Fall Creek, WIN815PTTestory Perry E · Urbana, ILN815SGGierisch Frederick · Utopia, TXN815VPBarrett Jeff K · Pollock, LAN81612Av8rlounge LLC · Columbia, SCN8161DDicey Aviation LLC · Somerset, KYN8161KSale Reported · Pendleton, ORSale reportedN8161NKale Timothy E · Kailua Kona, HIN8161PSpringer Dennis J · Salem, ORN8161WPs Air Group LLC · Cape May, NJN8162ADedominici Kenneth · East Bridgewater, MAN8162EMcmahan Steven C · Clay Center, KSN8162HPriest Peter J · Elk Grove, CAN8162QMcconnell Thomas R · St Simons Island, GAN8162RNoyes Daniel Ernest · Burton, MIN8162WBistline Fredrick G · Page, AZ
Back to AD 90-04-06 R1