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.
N8421JRegistered aircraftN8421RRoberts Darren C · Zionsville, INN8421YKesser Gilbert M · Culpeper, VAN84221Mcknight Michael D · Marietta, GAN84224Cordes Jeffrey A · Happy Valley, ORN84225Executive Flight Institute LLC · Murrieta, CAN84226Jackson County Aviation LLC · Sneads, FLN84227Jernigan Alex E · Warrensburg, MON84229Langenbahn Theodore John · Schoharie, NYN8422HDeevers Howard A · Tucson, AZN8422LHubert Kim J Trustee · Eagle River, AKN8422MDymond Mark S · Monterey, TNN8422NCenter Flying Inc · Lancaster, CAN8422RTascarella William M · Quakertown, PAN8422W642 Flying Club Of Fort Worth Inc · Fort Worth, TXN84234Mazelg Aviation LLC · Bartow, FLN8423DKearney Rick G · Amity, PAN8423LYoung James A · Toledo, WAN8423WGillanders Kenneth William · Carson City, NVN8424Huston Charles D · Austin, TXN84243Sjoberg Donald E · Poteau, OKN8424LMcgreen John R · Albany, NYN84250Wick James R · Canon City, CON84256Registered aircraftN8425FSons Aviation LLC · Moody, ALN8425WBenner James R · Goshen, INN84265West Gerald Lee · Two Harbors, MNN84267Shields Debra M · York, SCN8426POta Paul T · Grayslake, ILN8426RBryant Bryce E · Evans City, PAN84271Anderson Operations LLC · Fallon, NVN84275Rodriguez Norberto R · Inwood, NYN84278Ap Air LLC · Wilmington, NCN8427DEastin Toby M · Jefferson City, MON8427GWarrior II Ltd · Des Plaines, ILN8427KInternational Air Services Inc Trustee · Carson City, NVN8427RLopez Trinidad V · El Cajon, CAN8427TPierce Rex G · Shorewood, ILN8427WKsiezyk Donald G · Wadsworth, OHN8427YBiernacki David F · Rockford, ILN84289Angelov Ruslan P · Mount Prospect, ILN8428BHiggins James · Oxford, NCN8428DMullen Samuel J · Fairbanks, AKN8428HWilson Jessica D · Gallipolis Ferry, WVN8428SLand O Lakes Flying Club Inc · Bloomfield Hills, MIN8428WAces High Aviation LLC · Casper, WYN84293Nwa Flyers LLC · Missoula, MTN84299Phoenix Aviation Holdings LLC · Crystal Beach, FLN8429DDickson Wayne K · Luthersville, GAN8429WCleveland Tommy E · Mountain View, AR
Back to AD 90-04-06 R1