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.
N6540DCollon John C · Louisville, KYRegistration revokedN6540LSmith Thomas E · Williamstown, MAN6540WRiggs Charles A · Pembroke Pines, FLN65415Cal Aggie Flying Farmers Inc · Davis, CAN65417Frear Robert · N Redngtn Bch, FLN6541LOse Leroy B · Thief River Falls, MNN6541URegistered aircraftN6542HOwens Flight Training LLC · Lafayette, LAN6542VHarris Dakota · Goose Creek, SCN6542WBaird Philip D · Judith Gap, MTN65435Wings Over Texas Holdings LLC · Denton, TXN65439Pnl Aero LLC · Raleigh, NCN6543DBatte Randall E · Forest, MSN6543UGiesey William · Philadelphia, PAN6543VChupito Sabrocito LLC · Paso Robles, CAN6543WJts Aircraft LLC · Rock Hill, SCN65440G&M Aircraft Inc · Wheat Ridge, CON65442National Museum Of World War II Aviation · Colorado Springs, CON65449Hoeft Cliff A · Pilot Rock, ORN6544KWaldron Ronald J · Strongsville, OHN6544LPencoe Glenn L · Jemison, ALN6544TCourtney John T · Woodbridge, CTN6544WBrown Rayford K · Temple, TXN6545DCosta Flying Service Inc · Painted Post, NYN6545GBoomer Aviation Inc · Fort Walton Beach, FLN6545HAmerican Patrols Inc · Midland, TXN6545RBonilla-Cruz Carlos · Houston, TXN65468Burger John J · Ocala, FLN6546FMiljour Jack A · Sanborn, NYN6546UBadlands Flyers Inc · Watford City, NDN65470Jt Aero LLC · Wilmington, DEN6547JMeyer Mark A · Vass, NCN6547SMiller Bradley J · Joliet, MTN6547WMacclements Jonathan E · Austin, TXN65483American Aviation Inc · Brooksville, FLN65489Flight Solutions LLC · Columbia, MON6548ESewell William G Jr · Bremen, GAN6548JInspire Aviation LLC · Magnolia, TXN6548LJudge Christopher E · Vacaville, CAN6548VMaxwell Frank R · Fairbanks, AKN65495Circle W Flying Club Inc · Creighton, PAN65498Wings Over Texas Holdings LLC · Denton, TXN6549DBbjs Investments LLC · Waukesha, WIN6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeN6549ZRivers Larry R · Talkeetna, AKN654ACFlying Sparks LLC · Tomball, TXN654ALMoore Howard · Camden, TNN654BCCobb Charles J · Fallbrook, CAN654CRLinde Rodney C · Weatherford, TXN654EZN654ez LLC · Oyster Bay, NY
Back to AD 90-04-06 R1